Jimmasterton
New Member
- Joined
- Mar 13, 2018
- Messages
- 36
Hello everyone
I got such great help last time I posted a question and I hoped you could help me again.
I have got a workbook with 366 sheets in it, sheet 1 being the cover sheet.
On the cover sheet (sheet1) I have merged 3 horizontal cell (D14,E14,F14) to make a box for searchable words and put a button with a magnifying glass icon to the right of it.
What i would Like to be able to happen is, I type a word into the search box and click the magnifying glass search button and it jumps to the cell of the first instance of this word being found. There might be more than one time the same word is mentioned in all of the sheets, so, when the first search is done I would like a message box to appear saying
is this what you were looking for ?
If yes the selection should remain on this cell
If no the search should continue to the next instance of this word being mentioned eventually with a message box saying
no searches found
and when you press ok it returns to the cover sheet.
I would like a relaxed search if possible, so if the user searches for Smith and the cell contains David Smith it will still find it.
I have seen some other posts for search boxes but none like this, can you help me please?
I got such great help last time I posted a question and I hoped you could help me again.
I have got a workbook with 366 sheets in it, sheet 1 being the cover sheet.
On the cover sheet (sheet1) I have merged 3 horizontal cell (D14,E14,F14) to make a box for searchable words and put a button with a magnifying glass icon to the right of it.
What i would Like to be able to happen is, I type a word into the search box and click the magnifying glass search button and it jumps to the cell of the first instance of this word being found. There might be more than one time the same word is mentioned in all of the sheets, so, when the first search is done I would like a message box to appear saying
is this what you were looking for ?
If yes the selection should remain on this cell
If no the search should continue to the next instance of this word being mentioned eventually with a message box saying
no searches found
and when you press ok it returns to the cover sheet.
I would like a relaxed search if possible, so if the user searches for Smith and the cell contains David Smith it will still find it.
I have seen some other posts for search boxes but none like this, can you help me please?
Last edited: