S
Shatin
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
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