+ Reply to Thread
Results 1 to 2 of 2

Combo box

  1. #1
    Registered User
    Join Date
    08-29-2008
    Location
    Athens-Greece
    Posts
    2

    Combo box

    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.

  2. #2
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111
    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 http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Dynamically add pop up combo box with a click event
    By dovee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2008, 12:27 PM
  2. Sorting Data in Multiple Combo Boxes
    By ElsieC in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-18-2008, 10:26 AM
  3. Filter data using Combo Boxes
    By gsrai31 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-28-2007, 04:16 AM
  4. Combo Box doesn't drop down when chart in other pane is selected
    By rdfeigin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2007, 09:52 PM
  5. combo boxes options be linked to worksheet?
    By froggy19 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-13-2007, 04:42 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1