All the ones I'm finding are for older versions of Excel.
Is it possible to create a drop-down/pop-up calendar for a cell in Excel 2016/VBA?
All the ones I'm finding are for older versions of Excel.
Is it possible to create a drop-down/pop-up calendar for a cell in Excel 2016/VBA?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
That's for the older version of Excel. Microsoft took this out of the new Excel.
Last edited by AliGW; 11-23-2019 at 01:43 PM. Reason: Please don't quote unnecessarily!
You have Excel 2016 (according to your user profile and opening post). It says this:
Note. Microsoft's Date Picker control works with 32-bit versions of Excel 2016, Excel 2013, and Excel 2010, but it will not work on Excel 64-bit.
I missed that part where it says that the 64-bit version doesn't have that functionality. That's the version I have.
Last edited by AliGW; 11-23-2019 at 05:28 PM. Reason: Unnecessary quote removed.
Take a look at posts 3,4, and 5 in the following thread: http://www.excelforum.com/excel-gene...-combobox.html
The 'Calendar Form' works in both a Spreadsheet cell or in a UserForm.
The original file in post 3 does not compile in 64 bit Excel. Post 5 shows a fix for the problem.
Lewis
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks