Won't accept textbox3
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.
|