going to a cell that contain specific data
How this is implemented depends on what you do with your userform after the button is clicked....
Dim myR As Range
Set myR = Worksheets("Sheetname").Cells.Find(corp)
If Not myR Is Nothing Then
myR.Select
End If
HTH,
Bernie
MS Excel MVP
"Tom" wrote in message
...
Hi,
What i'm trying to do is setup a userform that lets the user select a name
then click on a button an goto that name on a sheet.
So far i have set up the userform and can select the name from a combo box
and have created a variable that holds what ever is selected in the combo
box
i.e. corp = ComboBox1.text
but i cant figure out how to take the user to the cell that contains the
same text.
i.e. if the user selects the name Bob i want to be able to take the user the
cell that contains Bob.
This wouldnt be problem if the cell that contains Bob was fixed, however it
is not fixed and moves.
Any ideas?
many thanks,
|