Hi all,
this is probably stupidly simple, but I can't seem to get it to work. I have a userform that has controls disabled to prevent the user from jumping straight to the "Submit" button without first entering in the data.
So the combobox1 when selected populates with dates from a worksheet. What I want to occur is the user selects a date from this combobox, which then unlocks the next combobox (combobox2 - this currently works fine) but then combobox2 displays the same date as combobox1 until the date has been changed by the user.
How can I do this?
Any help is appreciated.
Thanks,
Adam
this is probably stupidly simple, but I can't seem to get it to work. I have a userform that has controls disabled to prevent the user from jumping straight to the "Submit" button without first entering in the data.
So the combobox1 when selected populates with dates from a worksheet. What I want to occur is the user selects a date from this combobox, which then unlocks the next combobox (combobox2 - this currently works fine) but then combobox2 displays the same date as combobox1 until the date has been changed by the user.
How can I do this?
Any help is appreciated.
Thanks,
Adam