Won't accept textbox3

[davegb]

I'm using a userform to input data. When I put this line in my code:

sFacilName = TextBox3.Text

It keeps telling me TextBox3 is undefined. But it is in the userform. I
can't find any "definition" of Textbox1 in Walkenbach's example of a
userform. I also tried it with the other textbox in the form, doesn't
recognize that one either. So what is different about my code that it
doesn't recognize the controls in it?

Thanks.

[[email protected]]

where is your code - if it is on the userform, then it should be OK,
but if it is in a module outside of the code then you would need
userform1.textbox3.text

this may be one of those cases where it is useful to see the form so if
that DOESN'T resolve it my email is as my posting name!

davegb wrote:
> I'm using a userform to input data. When I put this line in my code:
>
> sFacilName = TextBox3.Text
>
> It keeps telling me TextBox3 is undefined. But it is in the userform. I
> can't find any "definition" of Textbox1 in Walkenbach's example of a
> userform. I also tried it with the other textbox in the form, doesn't
> recognize that one either. So what is different about my code that it
> doesn't recognize the controls in it?
>
> Thanks.

[ashishprem]

Hi Dave,
Your code is correct. Check once more whether textboz3 exists or not.
Otherwise delete the textboz and recreate it. Hope it will solve the problem.
Regards,
Ashish

[davegb]

Thanks to both of you. Finally got it working. I had to delete and
recreate both textboxes to get them to work. Don't understand why. Very
frustrating!

ashishprem wrote:
> Hi Dave,
> Your code is correct. Check once more whether textboz3 exists or not.
> Otherwise delete the textboz and recreate it. Hope it will solve the
> problem.
> Regards,
> Ashish
>
>
> --
> ashishprem
> ------------------------------------------------------------------------
> ashishprem's Profile: http://www.excelforum.com/member.php...o&userid=31485
> View this thread: http://www.excelforum.com/showthread...hreadid=550378