Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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
![]() |
|||
|
|||
![]()
Try naming the range, and then use the range as your source
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |