I was successful in creating a rudimentary test of ListBox following a variety of online tutorials. From the Properties box of ListBox>Format Control it is straightforward to drag/select "Input range". I seem UNABLE to select a range of "Cell links" in a similar fashion. The "Cell links" box indicates the range, e.g., $B$1:$B$10, but the only cell that works is the first (B1). Indeed, if I select (B2) & click on one of the ListBox options, the effect appears in B1. What?? In Microsoft tutorials the reference is always "cell", singular, not cell range, plural. I tried to "copy down" & it did not work (as I expected).
Is ListBox (or even ComboBox) fundamentally limited to a single cell? Does it become necessary to recreate the same ListBox for all the cells I need (maybe a couple dozen)?
Hoping I do not need to resort to VBA. I have no experience there.
I'm using Microsoft Office Professional Plus 2019.
Bookmarks