If statement not pulling values

I have 3 sheets in my excel document, one sheet is a pre-defined set of dates, on is a control page with selectable drop downs and buttons, and the third sheet shows the output of what im trying to do. On the control sheet you can select a month from a cell with a validate list, depending on what month you choose depends on which cell is selected on my date sheet. When i debug the script i get that my CurrentMonth string is returning as 0, rather than the string defined as below. Have i missed something blatantly obvious? I hope this makes some sort of sence!

Please Login or Register  to view this content.

Hi, if you do not put the string in a quote it will be consider it a variable. As you have not defined January/February etc the variable values will be 0.

Try:

Please Login or Register  to view this content.

Note - I would recommend writing code with "Option Explicit" -this will pick up on issues like this.

Maybe?

Please Login or Register  to view this content.

Originally Posted by ragulduy

Hi, if you do not put the string in a quote it will be consider it a variable. As you have not defined January/February etc the variable values will be 0.

Try:

Please Login or Register  to view this content.

Note - I would recommend writing code with "Option Explicit" -this will pick up on issues like this.

Cheers man, still in a steep learning curve with VBA! Great help though so thanks!