Search Tool

[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.

 

[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

 

[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.