Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I Disabled the Find Dialog Box?
Worms!
The only thing that comes to mind is worms. Do one thing and open a can of worms on something else. LOL For and unknown reason (to me), after running a macro, the "Find Dialog Box" will not open from the ribbon menu or by key commands (CNTRL F). Private Sub CommandButton1_Click() ActiveSheet.Cells.Select 'set first selection set sFindMe = TextBox1.Value 'get user value SearchWorkBook.Hide 'hide userform Application.Dialogs(xlDialogFormulaFind).Show sFindMe 'start find dialog and search End Sub What the heck did I do? -- Regards Rick XP Pro Office 2007 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programming the Find Dialog Box | Excel Programming | |||
Find Dialog Box | Excel Discussion (Misc queries) | |||
Find all results dialog box | Excel Discussion (Misc queries) | |||
Can the "Link to data in another Workbook Dialog Box" be disabled? | Links and Linking in Excel | |||
Find dialog Box | Setting up and Configuration of Excel |