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

--
HTH...

Jim Thomlinson


"Gerardo" wrote:

how to get the value of a text box in a sub or function (Not a private sub or
function)
without usirn UserForms

Not 100% sure what you mean with: without using UserForms.
If the form is loaded:

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


RBS

"Gerardo" wrote in message
...
how to get the value of a text box in a sub or function (Not a private sub
or
function)
without usirn UserForms