Combo box problem

[lkennemur]

I have place a combo box from the control toolbox and I am trying to populate it. I right clicked and chose Format. I do not have a Control tab listed. Is there a way for me to populate the combo box without creating a list on another worksheet?

Thanks

 

[Oaktree]

Welcome to the board.

In design mode, right click on it, go to properties, and populate the "ListFillRange" with A1:A10 or whatever. (LinkedCell works the same way)

 

[lkennemur]

Thanks!!