Setting combo box default value

M

mscertified

I have a combo box that contains the names of the 12 months.
I need to set a default value of the month before the current month.
I'd like to set the default via the offset in the list (via 'Datepart'
function) rather than the month name
e.g. 1 = January, 12=December etc.
Is this possible?
 
K

Klatuu

format(dateadd("m",-1,date),"mmmm")
The above will return "May" for for today's date
 
Top