Converting Integer Values To Months 1

[mattygriff]

I'm looking to populate a combo box with months - Jan, Feb, etc. - but want to avoid hard coding each option.

I know there's a way to do it but when I try, for example, a loop from 1 to 12 and then Format(loop,"mmm&quot I get a type mismatch error.

I'm probably being too simplistic - help please!!!

 

[FesterSXS]

try this...

MonthName(1)

Or..

Left(MonthName(1),3)



Tony

http://www.SpiraxSarco.com/cad

 

[mattygriff]

Thanks - have a star.

 

[FesterSXS]

You're welcome - thanks for star

Tony

http://www.SpiraxSarco.com/cad