S
Shiva
Hi,
I want the OnClickEvent of a button of my mainform to open another form. The
code of the mainform has to wait until the opened form has been closed. I
then want to read the button clicked on by the user (the buttons on the
form are "OK" and "Cancel").
In pseudo-code:
Code of the mainform's OnClick Event:
<begin code OnClickEvent>
- Open the form
- Set some properties of the controls of the form, e.g. the color of its
labels.
- Show the form (modal) and wait
- read the button being pressed
<end code OnClickEvent>
In Delphi this can be realized by using the ShowModal function. But how this
be realized in VBA?
Thanks a lot.
I want the OnClickEvent of a button of my mainform to open another form. The
code of the mainform has to wait until the opened form has been closed. I
then want to read the button clicked on by the user (the buttons on the
form are "OK" and "Cancel").
In pseudo-code:
Code of the mainform's OnClick Event:
<begin code OnClickEvent>
- Open the form
- Set some properties of the controls of the form, e.g. the color of its
labels.
- Show the form (modal) and wait
- read the button being pressed
<end code OnClickEvent>
In Delphi this can be realized by using the ShowModal function. But how this
be realized in VBA?
Thanks a lot.