Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a macro in which there is a variable called myDate, and myDate must
be entered in this format: mm/dd/yyyy. To make sure it will be done correctly, I have created a userform dlgDate with three dropdown lists: monthList, dayList and yearList. The elements of the lists are like this: - monthList: 01, 02, ...12 - dayList: 01, 02,...31 - yearList: 2003, ...2008 The flow of the master macro is like this: Sub masterMacro() code dlgDate.show more code End sub 1. What should I put into the userform's Sub OK_Click() to concatenate the right date? I have tried many times but failed. 2. Once I get the correct date string in the userform, how do I pass it back to the masterMacro to be used by myDate? TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
Listbox and Array questions | Excel Programming |