Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]()
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 |
#4
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nesting Combo Boxes /Returning an Array | Excel Discussion (Misc queries) | |||
Dynamic Combo Box | Excel Worksheet Functions | |||
connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
dynamic combo boxes | Excel Worksheet Functions |