| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Progmatically set "Application.Dialogs(xlDialogFormulaFind)" optio
The bit of code below opens the "find" dialog box with the text supplied by a
textbox on a userform. sFindMe = TextBox1.Value Application.Dialogs(xlDialogFormulaFind).Show sFindMe What I would like to do is set the search arguments and pass an "Enter" key response with out user interaction to the "find" dialog box. Basically the user would never see the dialog box at all. Trust me, its necessary. ;) Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| are default values possible for "Application.Dialogs(xlDialogSortSpecial).show "? | Excel Programming | |||
| "Window Trails" showing with Dialogs | Excel Programming | |||
| Problems with application.Dialogs(xlDialogFormulaFind).Show | Excel Programming | |||
| Application.Dialogs(xlDialogFormulaFind).....HELP!!!!!! | Excel Programming | |||
Threaded Mode
