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
EDIT: I've just realised that this actually does'nt display form1 when button 2 is clicked - so any help with this would really be appreciated!! I'm lost .....EDIT2: 5 minutes later and still lost. If I don't hide form1, then it works fine. But I only ever wan't one form to be visible. I'm gonna stop editing now...before I waste anymore space. O_o
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
Bookmarks