Results 1 to 4 of 4

Help Please?

This is a discussion on Help Please? within the Excel Questions forums, part of the Question Forums category; hello i was hoping that some one can tell me or show me how to get info in a combobox ...

  1. #1
    New Member
    Join Date
    Jun 2004
    Posts
    13

    Default Help Please?

    hello i was hoping that some one can tell me or show me how to get info in a combobox from one workbook to another.

    example, lets say i have a userform in workbook1 Sheet1 with a combo box that displays the content of cell a1From workbook 2sheet 2. ?

    if it can be done will it also work when workbook2 is close?

  2. #2
    DRJ
    DRJ is offline
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,856

    Default

    What you can do is setup a range of cells on the sheet with the combobox and have them equal the cells in the other workbook. This will work when the other workbook is closed as well.

    Then set the combobox to the values of the linked cells.

  3. #3
    New Member
    Join Date
    Jun 2004
    Posts
    13

    Default Re: Help Please?

    thank you but that one its not an option for me i need a macro sice i have so much info allready in this workbook.
    any ideas?

  4. #4
    DRJ
    DRJ is offline
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,856

    Default

    You could have the macro open the workbook. Fill the userform combobox (using additem) then close the other workbook.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com