View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Userforms and Dates

I'm getting month and year values from a user form. The months are in the
form January, February, etc. and the years are 2004,2005, 2006. I want to
get the date from the entered values and I've used this equation

PlanDate = Date( Me.cboPlanYear.Value, me.cboPlanMonth.Value,1)

For some reason, it gives me a compile error on this statement. What am I
missing?

Thanks