Using results of a combo box

  • Thread starter Rob In Redwood City
  • Start date
R

Rob In Redwood City

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
 
P

paul

have a cell =datevalue(1&month&year) where the month and year refer to the
cells returning the choices from your comboboxes,and custom format to how you
want
 
D

Dave Peterson

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