It would be something like this:
Private Sub CommandButton1_Click()
Range(txt1.Text & ":" & txt1.Text).Select
End Sub
--
Robin Hammond
www.enhanceddatasystems.com
"David Jensen" wrote in message
...
Hi everyone. I apologize in advance for the simple question...
I have a userform with a textbox that a user will input a column
identifier
into. For instance they will enter F in the textbox and after clicking
the
command button on the bottom of the form the program will select the
entire
column F and replace each instance of, say, the word "end" with the word
"final". It will do more than this but I just need help getting started
on
how to select the column based on the user's input into the textbox on the
userform.
Thanks in advance so much for the help.
Dave