ComboBox

**Thelt2000x** · 03-23-2011, 07:09 PM

Hello all,
I had a quick question. I use combo box from form controls. I am trying to make is so if I have a combo box and the person chooses "Yes" then another combo box will appear. If in the second combo box someone chooses no then another combo box will appear and so on. I have been looking this up for a really long time and haven't been able to find anything. Thanks

**MarvinP** · 03-23-2011, 07:27 PM

Hi,
I think the term is cascading combo boxes.

Read http://blogs.captechconsulting.com/b...mbo-boxes-part to see if this is what you want.

**Thelt2000x** · 03-23-2011, 08:33 PM

Thanks for that info. I may use it in the future. Unfortunately, this is not really what I am looking for. I am looking for something that will hide a combo box until a certain value is entered into that combo box. For instance, I want there to be 4 boxes. Combo box 1, 2, 3, 4. I would like box 1 to be shown and if that person chooses yes box 2 would pop up. If they choose no then I would like box 3 to show up. If someone can just give me the format for like 6 combo boxes (to be safe) to do this I would be very grateful. Having said all that, I am not even sure if this is possible.

Thanks to everyone for all the help. I really know nothing about any of this.

**MarvinP** · 03-23-2011, 09:07 PM

Find the attached with an example of what I think you want.

You can make the ComboBox.Visible property True or False.

**Thelt2000x** · 03-24-2011, 02:23 PM

Marvin,
Thanks for all the help. I am little confused with the spreadsheet you attached. I attached an example of what I am trying to achieve. Thanks for anyone who can help!

**MarvinP** · 03-24-2011, 08:45 PM

Hi,

You have put comboboxes on your sheet instead of on a userform. You will need to click on the combobox and then on Properties to get to the On_Change property. You need to trap the On_Change event to test if it is Yes or No.

I believe what you are trying to do is possible but there are much easier ways to accomplish a survey form.

How about not using comboboxes and simply do validation cells. Then test the cells for values on them changing and then move the selected cell depending on the answer. This would be a much easier way and not need Userforms or ComboBox (Shapes) controls.