Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() "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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula, Macro, or VBA code to find and insert | Excel Worksheet Functions | |||
Find macro with wildcard as part of code | Excel Programming | |||
Does anyone have an ad in or Macro code to find Phantom Links? | Excel Programming | |||
do anybody have a sample code for executing excel macro from vb code?<eom | Excel Programming | |||
Can't find Macro code | Excel Programming |