I Disabled the Find Dialog Box?

R

Rick S.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Progmatically set "Application.Dialogs(xlDialogFormulaFind)" optio 3
Word macro that can call cells out of Excel for a find and replace 0
Cells.Find: Why can't I pass a variable? 10
How to get Find dialogbox through VBA macro in Excel2007 11
Excel wait for Find Replace dialog box in Word 4
modeless dialog box 4
Insert "Find dialog box" edits into macro 3
Reset the macro assigned to Ctrl+F on workbook deactivate 11

Top