Returning a date value from combo box
 

Hi

I have a form which receives a project start date and project end date
information through combo boxes. I have set up three boxes one for date one
for month and the other for year. If I select the Start date by using the
three combo boxes, I want the date value mm/dd/yyyy to sit in a cell say "C8"
and like the same way for End date in "D8". Can somebody help me out? Thanks
in advance

KT

Returning a date value from combo box
 

Hi KT

Try this

Range("C8").Value = DateSerial(Me.Input1.Value, Me.Input2.Value, Me.Input3.Value)


--
Regards Ron de Bruin
http://www.rondebruin.nl



"KT" wrote in message ...
Hi

I have a form which receives a project start date and project end date
information through combo boxes. I have set up three boxes one for date one
for month and the other for year. If I select the Start date by using the
three combo boxes, I want the date value mm/dd/yyyy to sit in a cell say "C8"
and like the same way for End date in "D8". Can somebody help me out? Thanks
in advance

KT