Userform Name which includes Textbox creates Error

[senators40]

Hi,

I have a userform which has the Userform Name

What_a_Grey_Textbox_Means

In the coding I want to call up this userform - the coding shows up as

What_a_Grey_TextBox_Means.Show

The difference is that it converts the word Textbox into a capitalization of Box (presumably assuming that I wanted it to be a TextBox control feature)

It then gives you the following error

Compile Error Method or data member not found (Error 461)

I did convert the userform to read

What_a_Grey_Text_Box_Means

and it did work again.

This may be more of a helpful hint rather than a question but I was wondering if this was a new feature of Microsoft Visual Basic 6.5 In Excel 2002 (10.6841.6939) SP3 and if there is a way of turning this feature off (the conversion of Textbox to TextBox)

Thanks,

Jeff

 

[TonyJollans]

The capitalisation shouldn't matter; there must be something else happening here. Have you got something else with the same name?

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[mintjulep]

I can see "textbox" on its own as being a reserved word, and potentially causing problems, but it it seems like it should be ok buried in the middle of a long string.

Quite possibly the creature that parses all that is typed is getting a bit carried away.