| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Populating work sheet combox with another work sheet values
Hi All, I have a combox in my sheet(1) which i want to populate with values present in sheet(2). I can populate combox in sheet(1) by setting the "ListFillrange"property to the required ranges in the sheet(1) (assume in coulmn A i have values from A1: A5) But i am unable to populate same combox with sheet(2) values(assume in sheet(2) C column i have set of values from C1: C10). I want to populate without using any macros. Can anyone Please help me to solve this problem Thanks in advance -- sjayar ------------------------------------------------------------------------ sjayar's Profile: http://www.excelforum.com/member.php...o&userid=28435 View this thread: http://www.excelforum.com/showthread...hreadid=480347 |
|
#2
|
|||
|
|||
|
Populating work sheet combox with another work sheet values
Try naming the range, and then use the range as your source
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
| Save only values of one sheet | Excel Discussion (Misc queries) | |||
| linking values from one sheet to another | Excel Discussion (Misc queries) | |||
| Values in 'Balance sheet' template are in $ I want £ but there is. | Excel Discussion (Misc queries) | |||
Linear Mode
