Question
April 10, 2007 at 07:04 AM
teen_security

Function in Combo Box…

by teen_security . Updated 19 years, 6 months ago

Hi, I was making a Tour Program on Excel. I have created two Combo boxes…
One is Titled “No. of Adults” and the second one is titled “No. of Children”. And both of the combo boxes have same values in them…which are: 0,1,2,3,4
In the Tour program, you are not allowed to have more than 4 people. So what i’m trying to do is, i’m trying to put a function in my combo boxes so if i choose “1” in “No. of Adults”, the values in the second Combo box will change to “0,1,2 & 3”. Meaning because i chose “1” No. of Adult, i can have “0”,”1″,”2″, or “3” No. of Children for the tour.
But i can’t figure out how to do that, Please help. Thanks.

This discussion is locked

All Comments