Adding a "Take Me There" option to a Multiple Search criteria Macro ?

Hi - I have some VBA code that searches for a Text.value in all worksheets in a workbook via a USERFORM

The code works fine and returns a message box stating which worksheets the Text.values are in. I want it to bring up this Message box, but now give the option to "Take me there" rather than it just be the "OK" option.

As there may be more than one of the same Text.values in the workbook the current code loops and brings up each result one at a time, so would need 2 buttons in the result "Take me there" and "Continue" being the options until the loop ends with the final search return as "This It !" (or such like) - Hope that makes sense?

I really hope someone can help??

I'm learning all the time from the great responses from this forum ! THANKS ALL !

Here is my current Coding assigned to the USERFORM.......

Please Login or Register  to view this content.

Thanks for your reply - I will consider that option in the future

Originally Posted by Winon

Your chances of getting a response will be greatly increased if you attach a sample Workbook in this this Thread.

Hi - I have attached a simplified version of the workbook here.....

Many thanks.....

.
.
Here is a sample project you can use :

Please Login or Register  to view this content.