Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling drop down box
Range D2 is the GreeNPackage value. C5:C7 contains values for yes, D5:D7 contains values for no. Private Sub Worksheet_Change(ByVal Target As Range) If (Range("D2") = "yes") Then ComboBox1.ListFillRange = "C5:C7" ElseIf (Range("D2") = "no") Then ComboBox1.ListFillRange = "D5:D7" Else ComboBox1.ListFillRange = "" End If End Sub - Mangesh -- mangesh_yadav ------------------------------------------------------------------------ mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470 View this thread: http://www.excelforum.com/showthread...hreadid=320336 |
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc
|
|||
|
|||
Filling drop down box
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filling colour in drop down options | Excel Discussion (Misc queries) | |||
filling information from one cell and filling another. | Excel Worksheet Functions | |||
Zero Filling | Excel Discussion (Misc queries) | |||
Filling drop down box | Excel Worksheet Functions | |||
Filling drop down box | Excel Discussion (Misc queries) |