VBA combobox UserForm_Initialize

[Hilton1982]

HI

I have two comboboxes with data validations link to dynamic named ranges.

The first box is Months and the second is years.

When i open the userform i want the comboboxes to display the current month and year I know it needs to be done on the Userform Initialize but i don't know how?

Please assist?

Thanks,

[Norie]

How exactly are you populating the comboboxes?

[Hilton1982]

Norie,

See below code for Comboboxes

Please Login or Register  to view this content.

[Norie]

What's in your named ranges?

[Hilton1982]

January - December and 2000-2025

[Hilton1982]

Norie,

Any idee what to do with this?