#1   Report Post  
Steved
 
Posts: n/a
Default Find dialog Box

Hello from Steved

Question please

Is it possible when opening the Find Dialog Box
instead in the look in: which opens as formulas
as the default is it possible to chnge the Default
to Values.

Thanks In Advance.

  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Saved from a previous post:

Excel tries to help by remembering the last settings you used--except for the
first search in that session.

You can use that to your advantage.

You could make a dummy workbook and put it in your xlStart folder. Have a
macro in that workbook that does a find (and sets all the stuff the way you
like). Then closes and gets out of the way.


Option Explicit
Sub auto_open()

Worksheets("sheet1").Cells.Find What:="", After:=ActiveCell, _
LookIn:=xlValues, _
LookAt:=xlPart, SearchOrder:=xlByColumns, _
SearchDirection:=xlNext, MatchCase:=False

ThisWorkbook.Close savechanges:=False

End Sub

The workbook opens, does a find (to fix your settings) and then closes to get
out of the way.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Steved wrote:

Hello from Steved

Question please

Is it possible when opening the Find Dialog Box
instead in the look in: which opens as formulas
as the default is it possible to chnge the Default
to Values.

Thanks In Advance.


--

Dave Peterson
  #3   Report Post  
Steved
 
Posts: n/a
Default

Excellent Thankyou.
-----Original Message-----
Saved from a previous post:

Excel tries to help by remembering the last settings you

used--except for the
first search in that session.

You can use that to your advantage.

You could make a dummy workbook and put it in your

xlStart folder. Have a
macro in that workbook that does a find (and sets all the

stuff the way you
like). Then closes and gets out of the way.


Option Explicit
Sub auto_open()

Worksheets("sheet1").Cells.Find What:="",

After:=ActiveCell, _
LookIn:=xlValues, _
LookAt:=xlPart, SearchOrder:=xlByColumns, _
SearchDirection:=xlNext,

MatchCase:=False

ThisWorkbook.Close savechanges:=False

End Sub

The workbook opens, does a find (to fix your settings)

and then closes to get
out of the way.

If you're new to macros, you may want to read David

McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Steved wrote:

Hello from Steved

Question please

Is it possible when opening the Find Dialog Box
instead in the look in: which opens as formulas
as the default is it possible to chnge the Default
to Values.

Thanks In Advance.


--

Dave Peterson
.

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
Excel's Dialog Box Dialog Box Excel Discussion (Misc queries) 1 February 12th 05 01:53 PM
Using the Find tool in EXCEL TK Excel Worksheet Functions 2 February 11th 05 08:51 PM
How can I make the find dialog box appear as soon as I open a spr. christieb1975 Excel Discussion (Misc queries) 2 January 28th 05 07:47 PM
Excel has a "Find Next" command but no "Find Previous" command. Michael Fitzpatrick Excel Discussion (Misc queries) 2 January 11th 05 12:45 AM
VB Find and Replace Bony_Pony Excel Worksheet Functions 10 December 6th 04 06:45 PM


All times are GMT +1. The time now is 10:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"