PC Review


Reply
Thread Tools Rate Thread

I Disabled the Find Dialog Box?

 
 
=?Utf-8?B?UmljayBTLg==?=
Guest
Posts: n/a
 
      28th Sep 2007
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
zoom dialog box disabled tinks Microsoft Word Document Management 0 16th Sep 2008 06:54 PM
can the error dialog be disabled? =?Utf-8?B?Q2hhaW5zYXdEdWRl?= Microsoft ASP .NET 1 18th May 2006 04:12 PM
Activex Controls disabled error dialog in IE6 James Allen Bressem Windows XP Internet Explorer 3 9th Mar 2005 06:17 PM
Disabled Test Dialog button Terp Microsoft VB .NET 2 4th Jan 2005 09:29 PM
All the controls in the Dialog Editor are disabled Zachary Turner Microsoft Dot NET Framework Forms 0 17th Sep 2004 06:46 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:24 PM.