Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning date instead of 'not null' | Excel Worksheet Functions | |||
Formula for returning date entered by date on another worksheet | Excel Worksheet Functions | |||
Nesting Combo Boxes /Returning an Array | Excel Discussion (Misc queries) | |||
date calc returning #name? | Excel Programming | |||
Returning a date from a UserForm | Excel Programming |