What I would like is to create a set of instructions that will teach the user how to use the userform if they choose to do so. I'm not really concerned that all of the comboboxes and textboxes are visible as my code will not allow them to enter anything until it's done in sequence anyways ie; thickness then material then qty etc.
So, the 1st msgbox pops up as soon as userform1 opens and asks if you would like to learn how to use the calculator....yes = choose your material ( which is combobox 2 ), no = userform1.show ( this is as far as I can get )
Once combobox2 shows a material then a msgbox pops up to then choose your thickness which is combobox3
Once combobox3 has a thickness then.... blah blah blah ......you get the picture
Here is what I have so far....but now I'm stumped as I don't know how to track the event changes for my comboboxes.
Private Sub Workbook_Open()
Userform1.Show
If MsgBox("Would you like to learn how to use the gasket calculator", vbYesNo) = vbYes Then
MsgBox " Ok, first you must choose your material from the drop down box located at the top left of this program"
Else
Userform1.Show
Exit Sub
End If
End Sub
Any help is greatly appreciated