From Help: "When a UserForm is modal, the user must respond before using any
other part of the application. No subsequent code is executed until the
UserForm is hidden or unloaded."

Modeless means you can do other things in Excel while the form is still
showing.
--
- K Dales


"systematic" wrote:


Hi all,

Well, I'm a complete VB newbie - and just trying to get a handle on
things. I've sort of solved my problem, but was hoping someone could
explain it to me (MS Help and Google have only confused me more!).

I am delving into VB to try to build a quiz application in excel. In a
nutshell, the user will navigate from form to form, with each form
displaying a list of questions to answer.

I've created the first form, which captures the user information (name
and other info) and the second form - which will be an introductory
explanation. Now I'm trying to add some navigation controls.

I've made a "back" button on form2, which allows the user to navigate
back. This generated the modal error, which I managed to fix by trial
and error using vbmodeless command. Problem is I don't really
understand what I have done!

Could anyone explain the modal and modeless windows a little further to
me?

So far -

FORM1 LAUNCHES FROM THE EXCEL WORKSHEET USING A BUTTON -

-Sub TakeMDLtest_Click()

UserForm1.Show vbModeless

End Sub-

FORM 1 IS

Private Sub CommandButton1_Click()

UserForm2.Show
UserForm1.Hide

End Sub

AND FORM 2 IS

Private Sub CommandButton2_Click()

UserForm2.Hide
UserForm1.Show vbModeless

End Sub


I've cut out any irrelevant code from my forms...and my navigation
works fine like this. But I just need someone to confirm that this is
right?

My apologies about the length of this post for such a simple question -
I'm sure as I learn more, I will also learn to keep things short and
simple!

Thanks for your help :)

sys :)


--
systematic
------------------------------------------------------------------------
systematic's Profile: http://www.excelforum.com/member.php...o&userid=25294
View this thread: http://www.excelforum.com/showthread...hreadid=387984