Excel date picker: insert an excel date picker calendar into a workbook (excel 64 bit version)

Excel date picker: insert an excel date picker calendar into a workbook (excel 64 bit version)

Bitesize Excel

2 года назад

104,296 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

Mike B.
Mike B. - 14.09.2023 18:46

Hello, how to make Add-Ins in Developer appear ?

Ответить
Bernard Kruyne
Bernard Kruyne - 26.08.2023 04:00

Thanks for this explanation about MSFT's Datepicker add in. Unfortunately it appears as if the add in remains once invoked on top of the spreadsheet which makes it significantly INFERIOR to Samradapps Datepicker which unfortunately MSFT has chosen to block. Any information / suggestions on how to remove the MSFT datepicker, not just shrink it, but hide it until again required will be useful. Likewise any suggestions as to how to avoid MSFT's blackage of Samradapps is also welcome

Ответить
verapamil07
verapamil07 - 26.08.2023 00:22

Thanks for the video, the Add-ins work on my private excel but my company prevents any add ins so I simply can't use them. Absolutely incredible that MS decided to delete the date picker from the developer more.

Ответить
SNM111
SNM111 - 19.08.2023 22:19

The problem is if I want to validate a target cell for a particular range of date, excels validation is not responding to the input received from this date picker. The date picker is good but excel is shit. Am I wrong. ?

Ответить
Mel Stewart
Mel Stewart - 24.05.2023 08:28

Hello, how come my calendar does not go past September 2022.

Ответить
Richard Burton
Richard Burton - 06.05.2023 21:55

Instead of putting dates in mine just puts squiggly lines

Ответить
Samuel McKinnon
Samuel McKinnon - 31.03.2023 07:05

G'day. I put these calendars into all my spreadsheets and they appear to work great. However, 2 questions:
1- Is it possible to insert into a cell - ie. you click the cell and the calendar appears?
2- When I open the app on my phone and click on the calendar - it gives the option to reseize or move the calendar instead of picking the date. Is there a way you can fix the calendar in place?

Ответить
Don Mox
Don Mox - 13.03.2023 11:11

Thank you! You're wonderful!

Ответить
Doc Tari
Doc Tari - 26.12.2022 16:56

Can't use these calendars in most corporate environments where security has locked the operating system. Needs to be a native Microsoft object.

Ответить
A S
A S - 09.12.2022 10:57

Thank you this is helpful! Can this be copied to outlook email body too?

Ответить
sammy ben menahem
sammy ben menahem - 14.11.2022 08:09

Can use it in vba forms ?

Ответить
Deepak
Deepak - 05.10.2022 16:39

Thank you for your efforts. After searching for half an hour on net, I found this solution is best. 🤗

Ответить
The Arcane Whisperer
The Arcane Whisperer - 01.10.2022 04:05

Hi, I click on the calendar and date but the date in the excel cell is one day behind??

Ответить
William Jones
William Jones - 06.09.2022 20:44

Just.Get.To.The.Point. Just give us the information, and stop prattling on with the unnecessary bits.

Ответить
Suresh Kumar Reddy P
Suresh Kumar Reddy P - 13.07.2022 06:12

i need drop down calender mam

Ответить
Ranger
Ranger - 01.06.2022 19:18

It'a a hassle to always have to unprotect the worksheet for the mini calendar to work. Is there a way to use date picker on a protected sheet?

Ответить
UltimateisReady
UltimateisReady - 25.05.2022 18:47

I am using my university student account for Office 365 and whenever I get into the add ins it says the admin has disabled this option. This is a corporative decision from my universtiy so this is not going to change. Is there a way to manually install this add-in so I don't have to do it from excel itself?

Ответить
Mashudu Mashathini
Mashudu Mashathini - 15.03.2022 13:45

Your videos are very informative 👌

Ответить
Mashudu Mashathini
Mashudu Mashathini - 15.03.2022 13:44

When I press the add in box it shows a small tab not like your it only has (analysis toolbar, euro currency tools and solver add in)

Ответить
Travel With Marti
Travel With Marti - 07.03.2022 13:37

💖💖💖 another great video Wonderful . 💖💖💖

Ответить