Open Find dialogue box in a range

[GoKingBee]

I am sure this is simple, but I can't seem to figure it out.

I am trying to write VBA code to open the Find dialogue box. The part I am finding tricky is, I only want a certain range searched for the value the user is seeking.

I can record a macro to select the range and initiate the Find, but, the instead of the Find box staying open so the user can type in a search value, the find process completes based on the previous value entered.

That is why I am trying to figure out how to just open the Find box.

thx alot
Bill

 

[PHV]

Something like this ?
Application.SendKeys "^f"

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[TonyJollans]

Hi GoKingBee,

To display the dialog, use ..

[blue]Application.Dialogs(xlDialogFormulaFind).Show[/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

 

[GoKingBee]

Thanks to both for your replies - Tony, you were right on the money. What kind of source could I look at to find other such simple commands as this? I think they would be very useful to a new VBA person like myself.

Bill

 

[PHV]

What kind of source could I look at to find other such simple commands as this?
The magical F1 key when you are playing with the object brower.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[GoKingBee]

Who would have thunk it.
Thx alot
Bill