Help Please?

[Lukan]

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?

 

[DRJ]

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.

 

[Lukan]

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?

 

[DRJ]

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