Solved: Combobox linked to calender

[hypuk]

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]

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]

Hi p45cal

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

Mark