Help with ComboBox

[u813222]

I am using combobox from Control Toolbar on the worksheet "A" that should populate list of values from another sheet "B". Then from another workbook to read the value of this combo box. I tried to use VBA but it doesn't seem to work for me.




Thanks in advance

Lana

 

[KWMSeattle]

On sheet B, set up a named range for the values you'd like to see populate your combobox. Then go to sheet A and make sure you are in design mode on the control toolbar. Right click your combobox and select Properties. Under ListFillRange type in the name of your named range. Exit design mode and click your combobox. It should be populated.

To have another workbook read the value in the combobox go back into Properties and under LinkedCell select a cell on the same sheet as your combobox. Then have your other workbook link to that cell.