View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
davegb davegb is offline
external usenet poster
 
Posts: 573
Default Won't accept textbox3

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.