MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Find by value


Posted by Jim on May 30, 2001 2:00 PM

I have a spreadsheet that 80 people must use to do a "find" on. When the find dialog box comes up the default is formulas in the look in field. How can I make it so value is always the default?


Posted by Mark W. on May 30, 2001 2:13 PM

> When the find dialog box comes up the default
> is formulas in the look in field.

This is true when Find is first used after the
Excel application is launched. Once the "Look
in" selection is changed to Values it remains as
Values even after the Find dialog is closed.

Posted by Dave Hawley on May 30, 2001 9:19 PM

Hi Jim

You can make the default always Values by using a simple macro like this:

Sub MyFind()
Application.Dialogs(xlDialogFormulaFind).Show , 2
End Sub


You can actually nominate the default for all options by setting the argumnent.

If you need a hand with this, let me know.


Dave


OzGrid Business Applications

Posted by Jim on May 31, 2001 9:12 AM

The macro worked slick in bringing up the find dialog box. But the find didn't work. To test, I did a CTRL-F to bring up the dialog and the search worked fine. Why doesn't it work with this?