Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Populate a combo Box
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 |
#2
|
|||
|
|||
Define a name (Menu: InsertName...) 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...tid=3494&stc=1 Hope it helped Ola Sandström +-------------------------------------------------------------------+ |Filename: Book4.zip | |Download: http://www.excelforum.com/attachment.php?postid=3494 | +-------------------------------------------------------------------+ -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=378959 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Combo Box | Excel Worksheet Functions | |||
connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
dynamic combo boxes | Excel Worksheet Functions | |||
Populate embedded combo box | Excel Worksheet Functions | |||
Populate embedded combo box | Excel Worksheet Functions |