G Gerardo Dec 5, 2007 #1 how to get the value of a text box in a sub or function (Not a private sub or function) without usirn UserForms
how to get the value of a text box in a sub or function (Not a private sub or function) without usirn UserForms
J Jim Thomlinson Dec 6, 2007 #2 Depends on the type of text box you are using. If the text box is from the controls toolbox and is embeded in a sheet then something like this will do... msgbox Sheet1.Textbox1.Text
Depends on the type of text box you are using. If the text box is from the controls toolbox and is embeded in a sheet then something like this will do... msgbox Sheet1.Textbox1.Text
R RB Smissaert Dec 6, 2007 #3 Not 100% sure what you mean with: without using UserForms. If the form is loaded: Sub Test() Msgbox Form1.Textbox1.Text End Sub RBS
Not 100% sure what you mean with: without using UserForms. If the form is loaded: Sub Test() Msgbox Form1.Textbox1.Text End Sub RBS