I have a combo box in cell B2 with options of "1" and "2"
I would like to put a combo box in cell B4 that would populate based on
the selection made in cell B2, whe
If B2="1", a cell range from sheet2, cells A1:A4 would populate the B4
combobox
If B2="2", a cell range from sheet2, cells B1:B4 would populate the B4
combobox
Is this possible with a function or a
VB formula? Thanks!
--
case54321
------------------------------------------------------------------------
case54321's Profile:
http://www.excelforum.com/member.php...o&userid=24287
View this thread:
http://www.excelforum.com/showthread...hreadid=378959