Using result from text box as a variable
 

I'd like to create a text box(?) for the user to enter a vendor name, and
this name be used as my variable.
Thanks a lot!

Using result from text box as a variable
 

Lucia,

You could do something as simple as

Dim VendorName As String
VendorName = InputBox("Enter a vendor name:")
MsgBox "You entered: " & VendorName


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email on the web site)

"Lucia" wrote in message
...
I'd like to create a text box(?) for the user to enter a vendor name, and
this name be used as my variable.
Thanks a lot!