LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default Set up search box to, by default, search workbook in the extraoptions?

Well, I kept looking. I didn't find a solution to the workbook
problem, exactly. The only thing I could recognize amongst all the
find codes I found was one I stumbled is a message that said to select
all the sheets first. That does, indeed, work. But it sure is
scary! <g As an extremely last resort, I suppose I could leave a
modified script advising the user that the sheets are selected (though
don't know how to monitor the state so that this message would pop up,
say, once the find box was closed), but quite frankly, I'm not sure I
really want to go that route.

But there must be something ... So to further jumpstart this thread,
perhaps what I've found so far might help ... (?)

-------------------------------------------
Sub FIND__Standard_EXTENDED()
'SourceURL for idea to select all sheets first, then do a find:
http://www.excelbanter.com/showthread.php?p=817169
'SourceURL - Find: http://www.mrexcel.com/forum/showthread.php?t=71530
'SourceURL - Select Sheets (since SelSh giving me 1004 at home):
http://www.computing.net/answers/pro...h-vb/5902.html

'Sheets.Select ' didn't work at home
'ActiveWorkbook.Sheets.Select ' didn't work at home
'Sheets().Select ' didn't work at home

Sheets.Select ' works at office (???!!!)
Application.Dialogs(xlDialogFormulaFind).Show

End Sub
Sub FIND_Simple()
'SourceURL: http://www.mrexcel.com/forum/showthread.php?t=71530

Cells.Find(What:=InputBox("Please enter your search criteria",
"Search"), _
After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlPart, _
SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False).Activate
End Sub
-------------------------------------------

So the "sheets.select" in the "FIND__Standard_EXTENDED" above is not
ideal at all. Was hoping to find another way to get the find to be
able to search through the entire workbook.

The clue _might_ lie in the second find coding I found, shown above
with title "FIND_Simple". In the area where SearchOrder and
SearchDirection is found, is there no option for "search entire
workbook", or something? That way I don't leave the user vulnerable
with all the sheets selected? Again, it comes back to the problem
that I don't know what to search for so I can't seem to find
anything. I'm sure once someone provides the syntax, a ton of
messages come up <lol. That's assuming, of course, that this can
even be done without going the "sheets.select" route.

Thanks! Much appreciated! :oD
 
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
How do I change the Excel "search" default to WORKBOOK & DATA? danny bromberg Excel Discussion (Misc queries) 5 July 5th 09 06:44 AM
Changing Default Search in to Values Not Formulas in Excel Gregg Dotoli Excel Discussion (Misc queries) 1 January 1st 07 05:08 PM
Default Search Options Idaho Word Man New Users to Excel 2 November 20th 06 07:20 PM
IDE, Search - changing default Peter Ostermann[_3_] Excel Programming 1 June 27th 06 07:20 AM
Default Search in Workbook Kristin Excel Discussion (Misc queries) 0 January 3rd 06 10:35 PM


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