PDA

View Full Version : Solved: Combobox linked to calender



hypuk
10-06-2009, 02:13 PM
Hi there

I'm new to VBA and I'd like to add a combox to a userform, when the user clicks on the combobox a calender pops up, when a user selects a date, have the combobox populate with the date.

I'm sure this may have been posted before but I can't seem to find a solution.

Any help would be much appreciated

Thanks
Mark

p45cal
10-07-2009, 03:03 AM
instead of using a combo box, how about the Date/Time picker control? On the Toolbox toolbar/window, right-cilck in some empty space and choose Additional controls..., scroll down until youj see 'Microsoft Date and Time Picker Control ~~~", puit a tick in its checkbox and click OK, then you should have a new control to add to your user form. It can be tweaked wrt how it appears/behaves quiite a lot.

hypuk
10-07-2009, 09:35 AM
Hi p45cal

That's fantastic, work's a treat thanks for you help!!!!

Mark