Does Inputbox accept dates?
Posted by Fred on February 12, 2001 11:19 AM
I am new to this board and found it while i was searching for some codes in the net, hope i can find an answer.
What I would like to do is;
When someones open an excel file, a macro has to start without pressing a button this is the first thing, and the user will input 2 dates (1:starting and 2:end date -for a report-). The macro can write these values into a cell in this workbook that is no problem they will be hidden and locked.
The problem is I would like the user to select the date from some kind of a calendar like when you doubleclick the time in the right bottom of windows bar. If it's not possible, i want the user to enter the date in the correct format (like data entry in MS Access) or at least the user must enter 2 dates at one inputbox.
Thanks to anyone who could help...