turning string month into number

[Santiago Gomez]

Hello,
I have a combo box with the months January, February, etc.
Is there an easy way of converting that value into month numbers so I can
use it with a For Loop?
thanks

 

[Ken Snell]

Try this:

MonthNumber = Month(CDate(Me.cboBoxName.Value & " 1, 2003"))

 

[DanK]

Another way would be to have a second column that is zero
inches long and in it is the corresponding month number,
ie:

January 1
February 2
March 3
etc.

Then, use the data in the second column in your loops.

 

[Santiago Gomez]

that worked perfectly. I had created a Select statement 20 lines to do what
you did in 1 line.
thanks.

the hidden column would have worked, but I was using that value in other
places and did not want to change it everywhere.

 

[Ken Snell]

You're welcome.

that worked perfectly. I had created a Select statement 20 lines to do what
you did in 1 line.
thanks.

the hidden column would have worked, but I was using that value in other
places and did not want to change it everywhere.