Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I change the Excel "search" default to WORKBOOK & DATA? | Excel Discussion (Misc queries) | |||
Changing Default Search in to Values Not Formulas in Excel | Excel Discussion (Misc queries) | |||
Default Search Options | New Users to Excel | |||
IDE, Search - changing default | Excel Programming | |||
Default Search in Workbook | Excel Discussion (Misc queries) |