Changing The Find Default Dialogue.. Possible?

**Mhz** · 02-08-2007, 01:49 AM

Hi, Is there a formula or coding that can modify the Excel Find/Replace Default
settings? I notice when a program is reopened the default settings of the
'Find / Replace' are always reset to Search Within 'Sheet' instead of 'Workbook'.

I would also like to be able to have the 'Match Entire Cell Contents' Checked
Off as default when the Dialogue is opened. This May Not be Possible, but
thought I would at least ask... Thanks For any Help Here.

**Carim** · 02-08-2007, 03:08 AM

Hi,

If I recall correctly these settings are determined at Excel installation ...
So you are left with two possibilities :
1. Use VBA cells.find

Sub Macro1()
    Cells.Find(What:="", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
        xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
        ).Activate
End Sub

2. Design your own UserForm with your own option settings ...

**Leith Ross** · 02-08-2007, 03:34 AM

Hello Mhz,

There is a third option available, but only for expert level programmers. The Find/Replace dialog is not an Excel dialog, but a Windows System dialog. Excel provides a wrapper function to make this low level code easier to use.

At its heart there a 2 API (Application Interface) calls: FINDTEXT and REPLACETEXT. There are several other API functions used as well. To make all this work requires "hooking" into the Windows messaging system.

I vote for Carim's solution. It is easier and faster to do. The API is a very powerful programming tool, but requires care and a thorough understanding of what it is doing.

Sincerely,
Leith Ross

**Mhz** · 02-08-2007, 04:36 PM

Thanks Very Much... Could Not have gotten the Answers From a Better Source..

...
I'll try Carim's Alternate Workaround. I felt that It would be
a bit more complex based on what Ross Described... Man, It's Good to Have
Experienced Programmers around when you need them..

Thanks Alot...