reading text from text box

paulinenj

New Member
Joined
Oct 2, 2006
Messages
25
Hi,

I am trying to use the text that is entered into a text box to do a Vlookup. The code I have tried is:

Dim user As String
user = username.Text
Range("check") = user

I have also tried

Range("check") = username.text

It keeps getting stuck on the = username.text.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

paulinenj

New Member
Joined
Oct 2, 2006
Messages
25
Ah, nevermind.....I got it

Dim user As String
user = Sheets("LogIn").username.Text
Range("check") = user
 

Watch MrExcel Video

Forum statistics

Threads
1,114,676
Messages
5,549,374
Members
410,911
Latest member
AniEx
Top