Excell question - Open in Search mode

Yahoo Archive
1
Go to microsoft's technet site & you'll likely find code examples to do what you want as - you are correct - 'record macro' isn't capable of recording many things (and you have to hand code it).
Rob

--- Original Message ---
From:"Len Hartka" <len.hartka@...>
Sent:Wed 6/2/10 10:22 am
To:<vantage@yahoogroups.com>
Subj:[Vantage] Excell question - Open in Search mode

Good Day:

Excell question.
I know that a macro named "Auto_Open" will execute when the
worksheet is opened.
I can record the keystrokes: Tools >> Macro >> Record new Macro.
But, if I "'record" Edit >> Find and then stop the macro, the
Edit find does not open when I open the worksheet.

Anyone know how to open Excell in Find\Search mode?

I created a WS for my Manage-2000 history which I am putting in the
E9 Favorite Menu and would like for it to open in 'Find" mode.



len.hartka@...
Excell question - Open in Search mode

**************************************************************

Sun Automation Group

Celebrating

25 Years of Service

to the Corrugated Industry

**************************************************************




This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


[Non-text portions of this message have been removed]
2
Good Day:

Excell question.
I know that a macro named "Auto_Open" will execute when the
worksheet is opened.
I can record the keystrokes: Tools >> Macro >> Record new Macro.
But, if I "'record" Edit >> Find and then stop the macro, the
Edit find does not open when I open the worksheet.

Anyone know how to open Excell in Find\Search mode?

I created a WS for my Manage-2000 history which I am putting in the
E9 Favorite Menu and would like for it to open in 'Find" mode.



len.hartka@...
Excell question - Open in Search mode

**************************************************************

Sun Automation Group

Celebrating

25 Years of Service

to the Corrugated Industry

**************************************************************




This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


[Non-text portions of this message have been removed]
3
I don't think you can get there that way. You probably need to create your own search form. Then, you can pass the search parameter to the search box and it will do its thing. Here is some air code to get you started:

Dim strInput As String
strInput = InputBox("Search For:", "Search")
Cells.Find(What:=strInput, After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False).Activate


Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Len Hartka
Sent: Wednesday, June 02, 2010 7:22 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Excell question - Open in Search mode



Good Day:

Excell question.
I know that a macro named "Auto_Open" will execute when the
worksheet is opened.
I can record the keystrokes: Tools >> Macro >> Record new Macro.
But, if I "'record" Edit >> Find and then stop the macro, the
Edit find does not open when I open the worksheet.

Anyone know how to open Excell in Find\Search mode?

I created a WS for my Manage-2000 history which I am putting in the
E9 Favorite Menu and would like for it to open in 'Find" mode.



len.hartka@...<mailto:len.hartka%40sunautomation.com>
Excell question - Open in Search mode

**************************************************************

Sun Automation Group

Celebrating

25 Years of Service

to the Corrugated Industry

**************************************************************

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
4
Len,



Try Application.CommandBars.ExecuteMso "FindDialogExcel" or Application.Dialogs(xlDialogFormulaFind).Show



Regards,

Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Len Hartka
Sent: Wednesday, June 02, 2010 10:22 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Excell question - Open in Search mode





Good Day:

Excell question.
I know that a macro named "Auto_Open" will execute when the
worksheet is opened.
I can record the keystrokes: Tools >> Macro >> Record new Macro.
But, if I "'record" Edit >> Find and then stop the macro, the
Edit find does not open when I open the worksheet.

Anyone know how to open Excell in Find\Search mode?

I created a WS for my Manage-2000 history which I am putting in the
E9 Favorite Menu and would like for it to open in 'Find" mode.



len.hartka@... <mailto:len.hartka%40sunautomation.com>
Excell question - Open in Search mode

**************************************************************

Sun Automation Group

Celebrating

25 Years of Service

to the Corrugated Industry

**************************************************************

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]