![]() |
Combo Box in VBC
Hi:
First I would like to say that this site is so helpful. I have a combo-box created in VBC that ask the questions "Do you own a home". There is a drop-down list that says "yes or no". What can I do to set it up to where if they choose "no" another box would come up and they would have a choice of "would you like be become a homeowner"? -- Marcia3641 |
Create your second box and set it up as hidden then when your user selects
"No", make it visible, set focus to it and check for a response before allowing continuation "Marcia3641" wrote: Hi: First I would like to say that this site is so helpful. I have a combo-box created in VBC that ask the questions "Do you own a home". There is a drop-down list that says "yes or no". What can I do to set it up to where if they choose "no" another box would come up and they would have a choice of "would you like be become a homeowner"? -- Marcia3641 |
Thanks bigwheel, can you please let me know how to set it up as hidden.
-- Marcia3641 "bigwheel" wrote: Create your second box and set it up as hidden then when your user selects "No", make it visible, set focus to it and check for a response before allowing continuation "Marcia3641" wrote: Hi: First I would like to say that this site is so helpful. I have a combo-box created in VBC that ask the questions "Do you own a home". There is a drop-down list that says "yes or no". What can I do to set it up to where if they choose "no" another box would come up and they would have a choice of "would you like be become a homeowner"? -- Marcia3641 |
When the box is selected, you should be able to view it's properties one of
which will be Visible. Set that to False. Then in your code, you would have something like:- If comboxbox1.value = "No" then comboxbox2.visible = True End If "Marcia3641" wrote: Thanks bigwheel, can you please let me know how to set it up as hidden. -- Marcia3641 "bigwheel" wrote: Create your second box and set it up as hidden then when your user selects "No", make it visible, set focus to it and check for a response before allowing continuation "Marcia3641" wrote: Hi: First I would like to say that this site is so helpful. I have a combo-box created in VBC that ask the questions "Do you own a home". There is a drop-down list that says "yes or no". What can I do to set it up to where if they choose "no" another box would come up and they would have a choice of "would you like be become a homeowner"? -- Marcia3641 |
All times are GMT +1. The time now is 04:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com