PDA

View Full Version : Find ALL



Asterix
02-27-2008, 02:53 AM
Is there any way I can end (or suspend) a macro by leaving the excel "find all" dialogue (the find dialogue that shows a list summary of the found values) displayed for the user to scroll through the found values and make some changes.

In short, how can I pull the find all dialogue up?

Simon Lloyd
02-27-2008, 05:39 AM
I don't know about leaving a Find All box up, but, here's a workbook that has some modified code in for you, it uses a userform finds all occurrences of a value entered in an inputbox, then shows all the addresses in a listbox click any of the addresses and that address is selected.

Hope it helps!