Solved: Form Control vs. Control Box control

[TrippyTom]

Hi folks,

I have a situation where a coworker made a listbox from the FORMS toolbar. I think I need to change it to a listbox from the CONROL BOX toolbar so I can control it via code, but....

My research refers to the RowSource property, but I don't see that option at all. I'm not adding it to a userform. I'm adding it to the worksheet directly.

Is there any way I can get the same functionality with a listbox from the CONTROL BOX toolbar?

[Kenneth Hobs]

You can use the ListFillRange.

[TrippyTom]

Thanks.

I'm not even sure his original setup was made from the FORMS toolbar because I can't right click on it and choose "View Code." I'm not sure how he made them at all now, but anyway, your answer helped.

[Artik]

1. Add ListBox into a sheet from CONROL BOX toolbar.
2. Click on icon Properties in the same toolbar.
3. Fill in the items ListFillRange and LincedCell
4. Click on icon Design Mode.
Ready (probably). ;)

Artik

[Kenneth Hobs]

Your screen pic shows it to be a Forms toolbar control. The code for it is set in the Sheet's container of objects. Right click the sheet's tab and View Code to see it.

[lucas]

Right click on the listbox created from the visual basic toolbar-select properties and use Kenneth Hobs suggestion of ListFillRange