EXcel User Form Date Picker 2016
I use the 2016 Excel version where they deleted the date picker tool so I had to download it.
when I send the excel sheet to another computer, they can't use my macros because they didn't download the date picker tool. Is there a solution to this problem?
Hi,
One way would be to create your own date picker functionality. At its simplest that could be three drop down validation cells which contain lists for years, months and days. Alternatively a UserDefined VBA form with drop down combo boxes doing the same sort of thing.
More sophisticated would be a VBA form with a look-alike calendar presentation whereby you just clicked a day after selecting a year & month.
The ever Debra on her helpful Contextures site has one suggestion here http://www.contextures.com/exceldatepicker.html
If you google stuff like 'VBA calendar userform date picker code' you'll find other suggestions.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks