Ramachandran
New Member
- Joined
- Oct 17, 2011
- Messages
- 47
In sheet1 I have a combobox (dropdown) with a list of names from sheet2 - Column A.
In sheet2 I have the names in column A, and some other values in column B - let's say apples and oranges.
What I would like to have is two checkboxes on sheet1, one with the text apples and one oranges. When both are True, I would like the dropdown list to show the names of both the apples and the oranges, if only the apples checkbox are true then the list shows only apples, and when none are true, the dropdown list is empty.
How may I acheive this?
Thanks
In sheet2 I have the names in column A, and some other values in column B - let's say apples and oranges.
What I would like to have is two checkboxes on sheet1, one with the text apples and one oranges. When both are True, I would like the dropdown list to show the names of both the apples and the oranges, if only the apples checkbox are true then the list shows only apples, and when none are true, the dropdown list is empty.
How may I acheive this?
Thanks