If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filling drop down box
hi,
I have a drop down box in a cell. Based on a value of anohter cell I have to fill my drop down box. what i mean is, say if GreeNPackage is "No" then I want the drop down box to fill a range of values. But if the GreeNPackage is "Yes" then I want the drop down box to fill another set of values. how can i do this? plenty of thanks |
#2
|
|||
|
|||
Hi!
In the data validation, allow list source box, you can enter a formula to test for YES or NO: =IF(E1="YES",F1:F10,G1:G10) How it works: If cell E1=YES use the values in F1:F10 as the source for the dropdown, otherwise, use G1:G10 as the source. Biff -----Original Message----- hi, I have a drop down box in a cell. Based on a value of anohter cell I have to fill my drop down box. what i mean is, say if GreeNPackage is "No" then I want the drop down box to fill a range of values. But if the GreeNPackage is "Yes" then I want the drop down box to fill another set of values. how can i do this? plenty of thanks . |
#3
|
|||
|
|||
Instead of drop down you can use data validation list and create to
set of range names: First will have value yes and no and then we will have to create to other ranged names, named yes and no. in those ranges you keep your parameters that you want to show as option to users. Then in the cells where you want to have yes/no answer you set data validation to you Ye/no named range. Then in the cell where you want to show values for yes or no, you set data validation to =(indirect([Address of yes/no cell]). So when the user is selecting let's say yes, the list validation will be set by indirect to named range yes. This method will avoid writing any VB code.. If any questions, contact me. Regards, Nick wrote in message ... hi, I have a drop down box in a cell. Based on a value of anohter cell I have to fill my drop down box. what i mean is, say if GreeNPackage is "No" then I want the drop down box to fill a range of values. But if the GreeNPackage is "Yes" then I want the drop down box to fill another set of values. how can i do this? plenty of thanks |
#4
|
|||
|
|||
hey thanks nick..
it works :-) gr8! -----Original Message----- Instead of drop down you can use data validation list and create to set of range names: First will have value yes and no and then we will have to create to other ranged names, named yes and no. in those ranges you keep your parameters that you want to show as option to users. Then in the cells where you want to have yes/no answer you set data validation to you Ye/no named range. Then in the cell where you want to show values for yes or no, you set data validation to =(indirect([Address of yes/no cell]). So when the user is selecting let's say yes, the list validation will be set by indirect to named range yes. This method will avoid writing any VB code.. If any questions, contact me. Regards, Nick wrote in message ... hi, I have a drop down box in a cell. Based on a value of anohter cell I have to fill my drop down box. what i mean is, say if GreeNPackage is "No" then I want the drop down box to fill a range of values. But if the GreeNPackage is "Yes" then I want the drop down box to fill another set of values. how can i do this? plenty of thanks . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Drop down problems | Guernsey Gaz | Using Forms | 0 | November 17th, 2004 05:06 PM |
Linking drop down boxes | zaika | General Discussion | 2 | October 30th, 2004 04:42 PM |
Drop downs | Neil R | General Discussion | 2 | June 16th, 2004 12:00 AM |
Values in drop down box dynamic | Chris | Worksheet Functions | 1 | May 8th, 2004 07:25 AM |
Drop drow box - Help! | Crystal | Worksheet Functions | 4 | January 23rd, 2004 08:50 PM |