I am encountering an issue where I get the error "could not set the rowsource property. invalid property value".
I have a listbox and change the elements it refers to depending on what options a user selects.
The first time I set the RowSource property, it works perfectly. If I add items to the referred worksheet and update the Rowsource property everything is fine. When I go to change it after adding something to the original list, then I get the error.
For example, I cannot change the Rowsource property from "Element1!G122:I124"
to "Element3!Q122:S128" - get the error.
In the watch window I try to forcably change it to "Element1!G122:I123" (ie. referring to one less row - a minor change), and the debugger gives me the same error. However I can change it to "" (Null)