Limit Application.Dialogs(xlDialogFormulaFind).show to just one Worksheet ...

[adambc]

Have found various posts on this subject but none of them work!

I have the following line of VBA code ...

Application.Dialogs(xlDialogFormulaFind).show "", 2, 2, 1

... but I want it to only look at one (of 5) Worksheet ("All Data") ie not move onto the next Worksheet etc etc

Is there a way to do this?

 

[RoryA]

Why do you need to use the dialog at all?

 

[adambc]

Why do you need to use the dialog at all?

@RoryA

Is there an alternative?

 

[RoryA]

You could simply use an inputbox for the text to find, then use the range.find method to look in a specific range on the sheet in question (or the whole used range of the sheet).

 

[adambc]

You could simply use an inputbox for the text to find, then use the range.find method to look in a specific range on the sheet in question (or the whole used range of the sheet).

OK but how do I emulate “Find Next” which is key?

 

[RoryA]

What are you actually trying to do? Allow the user to interact with the dialog?

 

[adambc]

What are you actually trying to do? Allow the user to interact with the dialog?

Yes, but only for the active Worksheet ..,

But it’s made me think about what they actually want to do so hold fire (unless there’s an easy way to restrict the Find to the active WS?) while I get the users to define what they want to do?

Thanks as always …