Thread: Search Tool
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Search Tool

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.