I created a form with combo boxes to filter for info. Based on the 1st and last part of a serial number, it then filters the worksheet.
It updates the worksheet and shows the correct info I filtered for. How can I get this filtered info to a lsitbox on the same form.
Nothing I've tried will select the autofiltered range or assign it to a range name.
How can I get this info to display in a listbox.
I want the form to be the users only access.
Please help this dummy!
It updates the worksheet and shows the correct info I filtered for. How can I get this filtered info to a lsitbox on the same form.
Nothing I've tried will select the autofiltered range or assign it to a range name.
How can I get this info to display in a listbox.
I want the form to be the users only access.
Please help this dummy!