PDA

View Full Version : combo box


ashgull80
08-10-2007, 09:51 AM
hi
i have a combo box in a user form with a list of dates,
but how can i set it so that when the userform is open the combo box displays 'todays' date (not 10/08/2007, but tha date the userform is opened)
thanks ash
Bob Phillips
08-10-2007, 11:21 AM
How does the date that the userform is opened different from today?
ashgull80
08-12-2007, 03:50 AM
well it is, the day it is opened is 'today'!
Bob Phillips
08-12-2007, 05:24 AM
You're gonna hyave to explain that one to me!
mdmackillop
08-12-2007, 06:12 AM
I think I see. The combobox may be based on a RowSource of dates. How to select today's date from that list.
mdmackillop
08-12-2007, 06:35 AM
This returns the date, but not in the correct format!
mperrah
08-13-2007, 01:23 AM
Not sure if a data validation list would work, but if so...
If you use a cell range as the source to populate the list,
have the first cell show todays date in the source range,
and make the data validation list show the top cell initialy,
you can put a list of dates on a hidden sheet
and make the top date today
and the rest of the dates can be in what every series you need..
hope this helps.
Mark