Renaming control results in weird /unrecognized characters

[guyglk]

Hi there,

I have a calendar set up (Userform) where I have 12 label controls for the months, for quick month pick.
I want to name them sequentially as LblM1 (for January), LblM2 (for February) and so on..

When I type in LblM11 the "11" turns into 2 black diamonds with a question mark.
Apparently I cannot have "11" anywhere as part of a name control as it always results in the same behavior.
And if I am not quick to change the name within a few seconds after I hit enter, excel eventually crashes.


Is that a known issues? I have never had this issue before, I'm not new to VBA and the VBE.
I also made sure I type in English (I have other languages installed).
Any ideas why that is and how to fix this?

Thank you!

[Greg M]

Hi there,

No problems when using Excel 2106 - I don't have Excel 2007 so I can't test it there.

Code used in UserForm VBA CodeModule:

Please Login or Register  to view this content.

Code used in standard VBA CodeModule:

Please Login or Register  to view this content.

Hope this helps.

Regards,

Greg M