how to get the value of a text box in a sub or function

  • Thread starter Thread starter Gerardo
  • Start date Start date
G

Gerardo

how to get the value of a text box in a sub or function (Not a private sub or
function)
without usirn UserForms
 
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
 
Not 100% sure what you mean with: without using UserForms.
If the form is loaded:

Sub Test()
Msgbox Form1.Textbox1.Text
End Sub


RBS
 
Back
Top