use text box instead of list box in a userform

[still learning]

Hi

I’m using a list box in a userform that has the Letters A to Z
When the user wants to look up a word, he/she clicks on the letter and the box closes and the cursor goes to that range
Example: if A is picked, the cursor goes to A_A
If B is picked, the cursor goes to B_B

Private Sub CommandButton1_Click()
Sheets("Sheet1").Select
Select Case Me.ListBox1.Value
Case Is = "A": Application.Goto Reference:="A_A", Scroll:=True
Case Is = "B": Application.Goto Reference:="B_B", Scroll:=True

I am wondering if I could have a Text Box and the user would then just enter a letter.
If it can be done, what would the code be??

If I used something like this

With TextBox1 ActiveSheet.Range("ae3").Value = .Text
End With

How would I have a macro run base on a cell entry if the text box puts the letter in a cell on the sheet



mike

 

[Fluff]

If it can be done, what would the code be??

Exactly the same as the code for the listbox, but change ListBox1 to the name of your TextBox

 

[still learning]

Thanks Fluff
Yo make it soooooooooooooooooo easy

mike

 

[Fluff]

You're welcome & thanks for the feedback.