See attached Excel file.
This attached Excel file contains a form with a listbox on it. (You can open this form by clicking on the "Open Form" button.)
Notice that the listbox is populated because the "RowSource" of the listbox equals a named range. (i.e. in this case "Names2")
How do I make only visible rows show in my listbox.
(i.e. if I hide a couple rows, then click the "Refresh" button on the form, the hidden rows won't show.)
Is there a way to do this without using VBA to paste data to another sheet? (i.e. maybe there is a feature in the listbox that says: "Only show the visible rows in the named range.")