Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Using data from Fomulafind dialog in Find Method

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!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 90
Default Using data from Fomulafind dialog in Find Method

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.

On Sun, 24 Aug 2003 15:36:16 -0700, Donnie wrote:

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!


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Using data from Fomulafind dialog in Find Method


I am aware of this.

Thanks,
Donnie


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

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find method example Shinichi Excel Programming 3 August 22nd 03 10:39 PM
The find method Stuart[_6_] Excel Programming 0 August 5th 03 03:14 PM
Help with the Find method Mike NG Excel Programming 3 August 4th 03 07:15 PM
The Find Method Dick Kusleika Excel Programming 3 July 16th 03 07:59 PM
The Find Method Brad[_7_] Excel Programming 0 July 16th 03 03:23 PM


All times are GMT +1. The time now is 12:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"