Search entire workbook with control button

Hi all,

Was just wondering if it is possible to search an entire workbook for data which a user has input in say cell A1 on Sheet 1 (or a textbox), and then have them click on a 'search' button located next to the cell to find the data and take them to the cell where it's located? This sounds easy I know but I've spent all day trying to figure out how to do it and not having a great deal of experience with macros am having a bit of trouble!

Hopefully it's clear what I'm after but I'll reiterate:

- Data input by user in cell A1 (or textbox whichever is easier!)
- 'Search' button clicked after data entered
- User is taken to worksheet where that data is located and cell is highlighted

Any and all help very much appreciated.

Lock-e73 ;Þ

hi try this

Please Login or Register  to view this content.

steve

Thanks heaps Steve,

I think that will do it nicely. Did you just have that little bit of code hangin' about? If so it's mighty handy

Thanks again ... lock-e73

glad it helped

it help me when i asked the same question some time ago. but i forgot who gave it to me.

steve