how to call a text box?

**papermoon** · 06-02-2010, 02:08 PM

I have a userform and I want to call it in an if statement... i want to do something like if IsEmpty(Textbox) then
[code]

How do I call the textbox?

**Shane O** · 06-02-2010, 02:22 PM

if your form is called 'userForm1' then the code is

Please Login or Register  to view this content.

**papermoon** · 06-02-2010, 02:30 PM

i dont mean to show the textbox, i just mean to call the textbox like a variable.

**Richard Buttrey** · 06-02-2010, 02:36 PM

Hi,

Please Login or Register  to view this content.

HTH

**jaslake** · 06-02-2010, 05:03 PM

Hi papermoon

Perhaps you're looking for something like this

Please Login or Register  to view this content.

John

**romperstomper** · 06-02-2010, 06:07 PM

FYI, in order to be able to refer to the textbox's value, the userform must be loaded. If you simply refer to say Userform1.Textbox1.Value in your code, then the form will be implicitly loaded and you will get the default value of the text box - usually "". This is one good reason not to use the default instancing.

**jaslake** · 06-02-2010, 06:20 PM

Hi romperstomper

This

If you simply refer to say Userform1.Textbox1.Value in your code, then the form will be implicitly loaded

once or twice and I didn't know why. Thanks for the feedback.

John

**romperstomper** · 06-02-2010, 06:23 PM

That's why it's better to use something like:

Please Login or Register  to view this content.

and make sure that your form gets hidden not unloaded. Then if it has been unloaded somehow, you'll get an error when you try and access its controls/properties rather than a new instance created (which can make debugging really hard!)