View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Robin Hammond[_2_] Robin Hammond[_2_] is offline
external usenet poster
 
Posts: 575
Default Easy Userform question


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