topic Re: Name of userform Controls error in VBA Forum

Name of userform Controls error

Anonymous — Sat, 05 Nov 2005 15:30:49 GMT

Why on my userform when i change the value of .name property it will not allow me to use it in code?
Example. I have a textbox and i changed the .name = Height
Now why can't i use this syntax
NewVal = Height.name 'Gives an error stating invalid qualifier
'Instead i have to use this.
NewVal = textbox1.name

Re: Name of userform Controls error

Anonymous — Sat, 05 Nov 2005 15:49:50 GMT

height is a property of your textbox control.
don't use property names for object names.
It would be better if it didn't allow you to
use them at all.

height1.Name
textboxHeight.Name
...

--
gl - Paul
wrote in message news:5004921@discussion.autodesk.com...
Why on my userform when i change the value of .name property it will not
allow me to use it in code?
Example. I have a textbox and i changed the .name = Height
Now why can't i use this syntax
NewVal = Height.name 'Gives an error stating invalid qualifier
'Instead i have to use this.
NewVal = textbox1.name

Re: Name of userform Controls error

Anonymous — Sat, 05 Nov 2005 17:28:53 GMT

I see what you mean. thanks again Paul