3 Dialog Boxes - Skip 2nd Dialog Box when EditBox >10 
Author Message
 3 Dialog Boxes - Skip 2nd Dialog Box when EditBox >10

emailed and posted

Hi Don,

The following code includes the syntax to refer to the value in an Edit
Box; for this particular code, if the value is not a number an error
message will result.

If DialogSheets(1).EditBoxes(1).Text > 10 Then Beep

So you could use something like the following if your EditBox is on
Dialog2 (you didn't say):

If DialogSheets("Dialog2").EditBoxes(whatever).Text > 10 Then
        DialogSheets("Dialog3").Show
Else
        DialogSheets("Dialog2").Show
End If

Good luck,

Quote:

> I am using Excel 5/7

> I have 3 Dialog Boxes (Dialog1, Dialog2 and Dialog3)

> I am using them one after another (ie Next > - much like a wizard)

> What I would like to be able to do is skip Dialog2 if the value in
> Editbox (NOT input box) is > 10.

> Is this possible to do. I can't seem to work out the "value" of the
> Editbox.

> Any help would be appreciated.

> Thanks in advance

> Don



Tue, 19 Oct 1999 03:00:00 GMT  
 3 Dialog Boxes - Skip 2nd Dialog Box when EditBox >10

I am using Excel 5/7

I have 3 Dialog Boxes (Dialog1, Dialog2 and Dialog3)

I am using them one after another (ie Next > - much like a wizard)

What I would like to be able to do is skip Dialog2 if the value in
Editbox (NOT input box) is > 10.

Is this possible to do. I can't seem to work out the "value" of the
Editbox.

Any help would be appreciated.

Thanks in advance

Don



Tue, 19 Oct 1999 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Open file dialog box, Save as dialog box do not appear

2. Attaching macro to dialog box - editboxes

3. XL5:Editbox input to update dialog box labels ?

4. Formatting EditBox in Dialog Box with Date Format (mmmm-yy) - Excel 5/7

5. OfficeXP (10) Slow open file dialog box

6. Skipping Dialog box

7. CHECK BOXES - turning off ALL check boxes in a dialog box

8. CHECK BOXES - turning off ALL check boxes in a dialog box

9. filtering data using a text box in a dialog box into a pop-up box

10. dialog box with list box or combo box


 
Powered by phpBB® Forum Software © phpBB Group