I am looking for a control to add to userForm to enable a user to pick the date. I found a good one at this address
Formatting MM/DD/YYYY dates in textbox in VBA
from Siddharth Rout which is perfect but it generates invisible sheets which is not necessary for my application. I tried to stop creating sheets but I couldn't figure it out.
Can you please let me know how I can properly modify the Siddharth Rout code or point me to another application like that?
Thanks for your time
On the File menu, select Close and Return to Microsoft Excel. Select the Sheet1 tab. On the Tools menu, point to Macro, and then select Macros. Select CalendarMaker, and then select Run to create the calendar.
OFFICE 2013 INSTRUCTIONS:
(For Windows 7 (x64) | MS Office 32-Bit)
Option 1 | Check if ability already exists | 2 minutes
Option 2 | The "Monthview" Control doesn't currently exist | 5 minutes
Okay, either of these two steps should work for you if you have Office 2013 (32-Bit) on Windows 7 (x64). Some of the steps may be different if you have a different combo of Windows 7 & Office 2013.
The "Monthview" control will be your fully fleshed out 'DatePicker'. It comes equipped with its own properties and image. It works very well. Good luck.
Site: "bonCodigo" from above (this is an updated extension of his work)
Site: "AMM" from above (this is just an exension of his addition)
Site: Various Microsoft Support webpages
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With