ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combo Box in VBC (https://www.excelbanter.com/excel-discussion-misc-queries/36697-combo-box-vbc.html)

Marcia3641

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

bigwheel

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


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


bigwheel

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