ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   I Disabled the Find Dialog Box? (https://www.excelbanter.com/excel-programming/398325-i-disabled-find-dialog-box.html)

Rick S.

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



All times are GMT +1. The time now is 02:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com