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