Suppose you have two books: "Book 1.xls" and "Book 2.xls". In "Book 2.xls" in cells A1 to A5, we have some data. In "Book 1.xls" I want to put a combo box with matching these data (cells A1:A5 in the Book 2.xls).
Thanks in advance.
Suppose you have two books: "Book 1.xls" and "Book 2.xls". In "Book 2.xls" in cells A1 to A5, we have some data. In "Book 1.xls" I want to put a combo box with matching these data (cells A1:A5 in the Book 2.xls).
Thanks in advance.
G'day chemengeoge,
Basically......
Draw a combo box (Active X control box)
Open up its 'Properties' box
Select the 'Categorized' tab > 'Misc' > 'ListFillRange'
Then click in the cell next to the 'ListFillRange' and enter the cell location.
In your example '[Book2.xls]Sheet1'!$A$1:$A$5
Note:
Easy way to enter the right cell reference in the 'ListFillRange' is to click on a blank cell in Book 1 and enter in the equal sign (=) then select book2 the sheet then highlight the cell range then press enter.
Then go the formula bar and highlight and copy the cell path. Then go 'Properties' and paste in the cell reference you just copied.
HTH
Have I made you happy ??? If yes, please make me happy by pressing the Add Reputation button in my post.
Please don't forget to do the same to other contributors of this forum.
ThanksI don't void confusion, I create it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks