Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Accept or Reject a value | Excel Worksheet Functions | |||
Track/Accept Changes | Excel Worksheet Functions | |||
TextBox1.value=TextBox2.value-(TextBox3.value+TextBox4.value) | Excel Programming | |||
TextBox1.value=TextBox2.value-(TextBox3.value+TextBox4.value) | Excel Programming | |||
TextBox1.value=TextBox2.value-(TextBox3.value+TextBox4.value) | Excel Programming |