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.

Right click sheet tabview codecopy/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


--
Don Guillett
SalesAid Software

wrote in message
oups.com...
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.

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.


Don Guillett wrote:
Right click sheet tabview codecopy/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


--
Don Guillett
SalesAid Software

wrote in message
oups.com...
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.