With worksheets("sheet9999").Range("a1")
.NumberFormat = "mm/dd/yyyy"
.Value = CDate(Me.combobox1.Value & " 1, " & Me.combobox2.Value)
end with

Rob In Redwood City wrote:

This is probably a very simple question to answer since I am a newby.

I have a UserForm that has a combobox with the months and another with
the year.
I want this information to end up in cell A1 (with the first of the
month of that month)

example: if i pick September in the first combo and 2006 in the second,
I want 9/1/06 to appear in A1. How do I make this happen.

Thanks

--

Dave Peterson