Using data from Fomulafind dialog in Find Method

  • Thread starter Thread starter Donnie
  • Start date Start date
D

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
 
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.
 
Back
Top