View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] aidan.heritage@virgin.net is offline
external usenet poster
 
Posts: 244
Default 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.