Adding Rows after dropdown menu

N

newconcenemp

I am trying to add some subquestions after a Yes or No question. For example:

Does an IT system exist? (yes/no)
If yes, have we discussed a system? (yes/no)
Details

I have the question "Does an IT system exist" with a dropdown yes/no box and
if yes is chosen I want a row containing "If yes, have we discussed a
system?" and another yes/no drop down box to appear and then if yes is chosen
again, one last row with "Details" to appear.

This is just one example of what I need but I think if someone could show me
more or less the basics of how to insert a row with text after an answer is
chosen I could figure the rest out on my own (hopefully!)

Thank you for your help!
 
R

ryguy7272

If I were you, I'd use something like this:

YesNo = MsgBox("Has such and such happened?", vbYesNo, "Warning")
Select Case YesNo
Case vbNo
'If answer is Yes, no additional action needs to be taken...
Unload UserForm2
UserForm3.Show
Case vbYes '#1
'Insert your code here if No is clicked
YesNo = MsgBox("Does such and such happen?", vbYesNo, "Warning")
Select Case YesNo
Case vbYes
MsgBox "The User clicked YES!!"

Case vbNo '#2
YesNo = MsgBox("You answered no. Are you sure?", vbYesNo,
"Warning")
Select Case YesNo

Case vbYes
UserForm4.Show
Unload UserForm3

Case vbNo '#3
MsgBox "You answered no. Please start again!!"
Exit Sub

HTH,
Ryan---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top