Looping through months VBA code

Hello,

I am new here (and also for coding), please excuse me if i am not following the pattern.

Issue: i am trying to write a code which fills the 'textbox' by picking data from worksheet(ex - Function - January, Function - February,..) and cell address constant through sheets (Q12)

however, below thing isnt working and the user form doesnt show anything.

Please Login or Register  to view this content.

Your help is greatly appreciated.

Hi Harin,

Welcome to the Forum!

The month names need to be strings:

Please Login or Register  to view this content.

BTW - Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

There is also an issue with your worksheet syntax. It should be

Please Login or Register  to view this content.

Check this:

Please Login or Register  to view this content.

your original post suggests there is a space after the dash, which would be:

Please Login or Register  to view this content.

it is an important difference