Hi all
In a previous inquiry I was shown how to create a user form with a dynamic filter, to populate a list box based on data entered into a separate textbox.
I need though for the list box to be multicolumn, displaying the data from multiple columns in the source table, not just the cells that match the data in the textbox.
I cant seem to get my head around the code though, and if anyone out there is able to help me, it would be greatly appreciated.
please find link of current user form attached.
In a previous inquiry I was shown how to create a user form with a dynamic filter, to populate a list box based on data entered into a separate textbox.
I need though for the list box to be multicolumn, displaying the data from multiple columns in the source table, not just the cells that match the data in the textbox.
I cant seem to get my head around the code though, and if anyone out there is able to help me, it would be greatly appreciated.
please find link of current user form attached.
Book1.xlsm
Sheet1 one,two,three 1,Monday1,Monday 2,Tuesday2,Tuesday 3,Wednesday3,Wednesday 4,Thursday4,Thursday 5,Friday5,Friday 6,Saturday6,Saturday 7,Sunday7,Sunday 8,Monday8,Monday 9,Tuesday9,Tuesday 10,Wednesday10,Wednesday 11,Thursday11,Thursday 12,Friday12,Friday 13,Saturday13,Saturday 14,Sunday14,Su...
docs.google.com