I am using a ActiveX Listbox on a dashboard as a display device. I run an advanced search on a source table. That search result is copied to a hidden sheet and its results are displayed in the listbox via the listfillrange. The source in this case is a register (like a check register).

I have 4 different source tables.. cash, checking, savings etc . Each will have its own search criteria and separate ‘copy to’ areas on the hidden sheet. What I need to know is how, perhaps with radio buttons, can I switch the input of the listbox to different data ranges

I really don’t have a usable file to upload but the focus of the question is pretty narrow.

Thanks
Scott