Search Tool

D

david_lcfc

It would be useful to have a search tool implemented in Excel that
would allow the user to select from a list, afterwards the user would
be transported to the cell from the list. Does anyone know hoiw to
implement this.
 
D

Don Guillett

Right click sheet tab>view code>copy/paste this. now when you have t4 in a
cell and double click on that cell you goto it

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Range(ActiveCell).Select
End Sub
 
D

Dave

I'm looking for a combo box search tool that will take the user to the
cell say near the bottom of the page if they selected it.
 
Top