I want an embedded listbox (with headers) on my excel spreadsheet, that references a range on the worksheet. So using the ControlBox Toolbar I created a listbox. First thing I noticed is that there is no RowSource property appearing for this listbox. So I tried to enter the range using the ListFillRange property, both codewise and just manually in the listbox properties window. Nothing I enter has any effect. How does one embed a listbox and then give it a range of cells? It certainly is possible for listbox's placed on vb forms.
Note: This is not the kind of listbox created with the Forms toolbar. I would prefer to avoid having to use that listbox if necessary (for one, I cannot seem to create headers with it).