Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 29
Default Find & macro code

I want to have the Find & Replace dialog box open as soon as I open a
workbook so that I can scan in a locator number and do a search for all
records that match.
Does anyone one know what code I can use and where I would place it for this
purpose.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default Find & macro code

Hi Tony,

Try:
'=============
Private Sub Workbook_Open()
Application.Dialogs(xlDialogFormulaFind).Show
End Sub
'<<=============

This is worksheet event code and should be pasted into the worksheets's code
module (not a standard module and not the workbook's ThisWorkbook module):

Right-click the worksheet's tab
Select 'View Code' from the menu and paste the code.
Alt-F11 to return to Excel.


---
Regards,
Norman



"TonyD" wrote in message
...
I want to have the Find & Replace dialog box open as soon as I open a
workbook so that I can scan in a locator number and do a search for all
records that match.
Does anyone one know what code I can use and where I would place it for
this
purpose.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 313
Default Find & macro code



"TonyD" wrote:

I want to have the Find & Replace dialog box open as soon as I open a
workbook so that I can scan in a locator number and do a search for all
records that match.
Does anyone one know what code I can use and where I would place it for this
purpose.


Hi Norman copied the code as you mentioned by right-clicking the sheet,
selecting view code and then pasyting the code. I then saved the file and
reopened the file but no Find box appeared.
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
Formula, Macro, or VBA code to find and insert Keith Excel Worksheet Functions 3 October 2nd 09 08:21 PM
Find macro with wildcard as part of code excelnut1954 Excel Programming 2 June 14th 06 08:46 PM
Does anyone have an ad in or Macro code to find Phantom Links? Darren Excel Programming 2 May 18th 06 07:53 PM
do anybody have a sample code for executing excel macro from vb code?<eom B Deepak Excel Programming 2 September 30th 05 09:59 AM
Can't find Macro code jd17 Excel Programming 6 December 7th 04 06:23 PM


All times are GMT +1. The time now is 09:09 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"