Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter date in userform using Calendar Control
I am trying to fill in a userform textbox with a date the user selects out of
a pop-up calendar. I have the pop-up calendar created using the Calendar Control feature. Also I am able to push the date to a cell, but I would like the date to populate in the userform as a form of feedback. Also I need the user to enter two different dates using the pop-up calendar. I have been trying to pass the data usign a variable, but am unable to get that to work. Any insight would be greately appreciated. Scott |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter date in userform using Calendar Control
Figured it out. Ended up using a "Public blnNum As Boolean".
"Scotty9349" wrote: I am trying to fill in a userform textbox with a date the user selects out of a pop-up calendar. I have the pop-up calendar created using the Calendar Control feature. Also I am able to push the date to a cell, but I would like the date to populate in the userform as a form of feedback. Also I need the user to enter two different dates using the pop-up calendar. I have been trying to pass the data usign a variable, but am unable to get that to work. Any insight would be greately appreciated. Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ENTER A DATE USING CALENDAR CONTROL | Excel Discussion (Misc queries) | |||
need to display the excel atcive control calendar to enter dates | Excel Discussion (Misc queries) | |||
How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
Calendar control on cell enter? | Excel Worksheet Functions | |||
How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) |