Issue with listbox using dynamic range as listfillrange

[ryantuck]

Hello,

Here is the workflow I'm trying to achieve and where my problem arises:

1. I select option A, B, or C from a group of option buttons.
2. Based on my selection, a dynamic range, dictated by the OFFSET function, is displayed in a listbox.
3. My listbox is a multi-selection listbox, so I select multiple items from my listbox.
4. I have a command button "Update" that I click to copy the selected items from my listbox to the first row of a table. This table is used as the source data for a chart.

Issue: All of this functions more or less perfectly, except that it only works if the listbox draws from a static range. If the listbox is set to draw from a dynamic range, clicking "Update" will "reset" the listbox, thus unselecting all the selections I had made thus far.

I have posted an attached spreadsheet on ozgrid.com here to display the problem. If anyone has any idea how to solve or work around this issue, it would be immensely appreciated.

Thank you very much for your time.

BTW both listbox and optionbuttons are in a worksheet and are activeX controls.

Ryan

 

[jasonb75]

If the dynamic range appears to be the problem, use VBA to make it a fixed range, either by recycling the existing range name, or by using a temporary one.

 

[ryantuck]

Jasonb,

Thanks a lot for the suggestion. That was a super-easy fix.