Populate a combo Box

[case54321]

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 o
the selection made in cell B2, where:

If B2="1", a cell range from sheet2, cells A1:A4 would populate the B
combobox

If B2="2", a cell range from sheet2, cells B1:B4 would populate the B
combobox

Is this possible with a function or a VB formula? Thanks

 

[olasa]

Define a name (Menu: Insert>Name...) and then use the offset function
Name: range
Formula: =OFFSET(Sheet9!$D$7:$D$9;0;Sheet9!$B$7-1)

Also see encl. zip-file:
http://www.excelforum.com/attachment.php?attachmentid=3494&stc=1

Hope it helped
Ola Sandström


+-------------------------------------------------------------------+
|Filename: Book4.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3494 |
+-------------------------------------------------------------------+