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 |
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 |
All times are GMT +1. The time now is 09:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com