Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search with "Workbook" and "columns" built-in somehow?
I did a lot of looking at the archives and found this simple code
brings up the search box, which is what I needed: -------------------- Sub SearchWorkbook() CommandBars("Edit").Controls("Find...").Execute End Sub -------------------- I found all sorts of other code but nothing pre-defines some of the parameters for the search, which would be extremely helpful. In this thread, http://groups.google.ca/group/micros...143a5a7e?hl=en, Tom Ogilvy says these 2 things: 1. "When you show a builtin dialog in excel, you have lost control of it.", and 2. "You can feed it some arguments when opening". Sometimes the Find box comes up with the options opened, sometimes not. Something like this is neat: -------------------- Sub Search() Application.Dialogs(xlDialogFormulaReplace).Show End Sub -------------------- but doesn't have much pre-determined. How could one have a box come up that allows us to just enter what we need to search for, then when we press okay, it starts the search in the entire workbook? Thank you! :oD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=IF(ISNUMBER(SEARCH("ELB",B2)),"Pipe") add more like "ELB" "FLG" | Excel Worksheet Functions | |||
=IF(ISERROR(SEARCH("insurance",A125,1)),"","*") | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Sending macro based e-mail with built-in "Heading" and "Text" | Excel Programming |