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