Using data from Fomulafind dialog in Find Method

[Donnie]

I notice that when I run a macro with Find method and then use the
Edit|Find menu, the "what" from the Find method is displayed in the
"Find What" text box on the "Find" dilaogbox?

Is there any way for me to access that "Find What" on the "Find"
dialogbox to use in the Find method in VBA?

Thanks,
Donnie


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Wild Bill]

I don't know if it's directly accessible but be aware of the persistence
of some but not all elements of .Find. They are shown in the Remarks
section of VBA help for Find Method.

What you see in the dialog box will reflect exactly that persistence.

 

[Donnie]

I am aware of this.

Thanks,
Donnie


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!