#1   Report Post  
Marcia3641
 
Posts: n/a
Default 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
  #2   Report Post  
bigwheel
 
Posts: n/a
Default

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   Report Post  
Marcia3641
 
Posts: n/a
Default

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   Report Post  
bigwheel
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Nesting Combo Boxes /Returning an Array ELMONDO SNITHER Excel Discussion (Misc queries) 1 June 30th 05 01:15 AM
Dynamic Combo Box benjarfer Excel Worksheet Functions 2 April 8th 05 02:17 PM
connecting combo boxes to yield data in another cell. TxN8tv Excel Discussion (Misc queries) 0 March 14th 05 04:07 PM
"Combo Box - getting control combo box to stick in place in worksh ajr Excel Discussion (Misc queries) 0 February 15th 05 07:45 PM
dynamic combo boxes tjb Excel Worksheet Functions 2 January 25th 05 07:33 PM


All times are GMT +1. The time now is 07:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"