Well, I have searched for about 2 hours... Tried 100 things and am at the point of deleteing a 4 month project.
I have a dynamic named range using Offset and Match "=OFFSET(Selections!$B$53,0,0,MATCH("*",Selections!$B$53:$B$153,-1),1)". The values in B53 to B153 are dynamic based on cell B5. I may have a list of 10 items or 100 or even 0.
I have a userform with 8 listbox selections. 1 of the listbox selections controls 3 others. While the contents of the listbox change. The number of items in the list is not dynamic. If I open the form with 12 items in my range then I am stuck with a limit of 12 items in my listbox. I would like to change the number dynamicaly. I would like the listbox to work more like data validation, where I don't have an issue.
I do not want to see ".additem" or any form of picking cell B12031031993 and using xlup!
Bookmarks