Pre-Setting ComboBox Value

I have a UserForm which asks for a date with three separate ComboBox (month, day, year).

I have initialized them as follows:

Please Login or Register  to view this content.

What I am trying to do is pre-set them with the current date. I have attempted it with the commented out code at the bottom which gives an error "Type Mismatch"

Any ideas on how I can successfully pre-set them?

Thanks!

Also posted at: http://www.mrexcel.com/forum/showthr...15#post2382015

Putting all the dates of the year into one combobox would make it very large, no?

I am not familiar with how this code works. Could you please explain exactly what it does?

Thanks

Edit:

I tried the code and it works fine with displaying the dates, but today's date is not pre-selected, which is what I need. Is there any way to add on to that?

There's an example of using Comboboxes for dates here

http://excel-it.com/free_addins.htm

snb,you've already been asked when posting complex code,in my opinion overly complex, to add explanations.

You never seem to bother following up on any requests from members