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
