VBA combobox UserForm_Initialize

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,

See below code for Comboboxes

Private Sub UserForm_Initialize()
  Dim cbM As Range
  Dim cbY As Range
  Dim ws As Worksheet
  Set ws = Worksheets("DataValidation")

For Each cbM In ws.Range("monthlist")
  With Me.cbMonth
  .AddItem cbM.Value
  End With
Next cbM

For Each cbY In ws.Range("yearlist")
 With Me.cbYear
 .AddItem cbY.Value
 End With
Next cbY

Me.cbMonth.NumberFormat = "mmmm"
End Sub

January - December and 2000-2025

Norie,

Any idee what to do with this?