Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms and Dates
Hi Barb
You must load the combobox with two columns 1 Jan 2 Feb Hide the first column so you only see the month names Then use Bound column to read the numbers and not the month name -- Regards Ron de Bruin http://www.rondebruin.nl "Barb Reinhardt" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms and Dates
first, Date is what you would use in a worksheet,
DateSerial would be used in VBA. But either one expects a number for month. for your values use PlanDate = DateValue(me.cboPlanMonth.Value & " 1, " & Me.cboPlanYear.Value) or for international considerations PlanDate = cDate(me.cboPlanMonth.Value & " 1, " & Me.cboPlanYear.Value) -- Regards, Tom Ogilvy "Barb Reinhardt" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms and Dates
Maybe easier to use the listindex it this case
Fill the combo with month names and it your Dateserial use me.cboPlanMonth.ListIndex + 1 -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Barb You must load the combobox with two columns 1 Jan 2 Feb Hide the first column so you only see the month names Then use Bound column to read the numbers and not the month name -- Regards Ron de Bruin http://www.rondebruin.nl "Barb Reinhardt" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need some help with userforms | Excel Discussion (Misc queries) | |||
Userforms | Excel Programming | |||
Userforms | Excel Programming | |||
dates in userforms | Excel Programming | |||
dates in userforms | Excel Programming |