|
|
||||||
|
#1
12-08-03, 06:14 AM
|
|
|
|
|
1. Please examine the following code :-
Dim TextFind As String Call Application.Dialogs(xlDialogFormulaFind).Show(Text Find, 2, 2, 1, 0, True, True) MsgBox "TextFind = " & TextFind 2. It is in vain to store the text string (entered into the Find What : text box of the built-in xlDialogFormulaFind) by using the argument TextFind. 3. Please show the alternative means of capturing TextFind by using VBA code. 4. Regards. |
|
|
|
#2
12-08-03, 08:38 AM
|
|
|
|
|
Use the FIND method...look in Help. There are some very
good code examples therein. With Worksheets(1).Range("a1:a500") Set c = .Find(2, lookin:=xlValues) If Not c Is Nothing Then firstAddress = c.Address Do c.Value = 5 Set c = .FindNext(c) Loop While Not c Is Nothing And c.Address <> firstAddress End If End With Patrick Molloy Microsoft Excel MVP >-----Original Message----- >1. Please examine the following code :- > >Dim TextFind As String >Call Application.Dialogs(xlDialogFormulaFind).Show (TextFind, 2, 2, 1, >0, True, True) >MsgBox "TextFind = " & TextFind > >2. It is in vain to store the text string (entered into the Find What >: text box of the built-in xlDialogFormulaFind) by using the argument >TextFind. > >3. Please show the alternative means of capturing TextFind by using [..] |
|
#3
12-08-03, 08:40 AM
|
|
|
|
|
TKT-Tang wrote:
> 3. Please show the alternative means of capturing TextFind by using > VBA code. > I think there is none. You would do better to get the TextFind via an InputBox and then use it in the Find method. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup |
|
#4
12-09-03, 08:33 AM
|
|
|
|
|
Mr. Manville and Mr Molloy,
Thank you for your replies. Regards. Yours faithfully, TKT-Tang. |
|
|
| Similar Threads | |
| How to access built-in dialog boxes How do you find the numeric value of a built-in dialog box, such as: Dialogs(1347).Show to display the Modify Style dialog box? I am interested in accessing the Fill... |
|
| How to find names for built-in dialog boxes Is the list that comes up in the VB Editor as you type Dialogs( the full list available? In particular, I'm trying to find out how to call the "Modify Style"... |
|
| Using built in dialog boxes - how to determine arguments? How do I find out what the arguments/members of a given Word.Dialog are? I can invoke them fine using the code from: [..], and I can get some information on member names... |
|
| Built-in Dialog Boxes Is there anyway you can display dialog boxes using VBA. For example, would like to display the Save As dialog box, if a presentation has no already been saved, just before... |
|
| Customizing Word Built-In Dialog Boxes I am showing the Insert Table of Contents dialog box using VBA. "Dialogs(wdDialogsInsertTableofContents).Show" When i do this, the Show Levels box has a 9 in it. How can I... |
|
|
All times are GMT. The time now is 12:02 PM. | Privacy Policy
|
Re : Making use of the Built-in Dialog Boxes