I have a userform set-up to autofilter 22 colums of data, Shown in a listbox. There are five different criterias you can use to get the stated result. That all works fine.
What I want to be able to do is after sorting by certain criteria beable to select an entry in the listbox. (I use the second column in which I have a mm/dd/yy hh:mm:ss format set-up.) and print it to another worksheet.
Believe it or not this all works fine if I have not filtered the list at all. Once I filter the list using any of the five criteria, the filter results come back with all entries.
I am using this code to filter by after making the selection.
Selection.AutoFilter Field:=2, Criteria1:=raloku.ListBox1.Value
Any ideas would be appreciated.
What I want to be able to do is after sorting by certain criteria beable to select an entry in the listbox. (I use the second column in which I have a mm/dd/yy hh:mm:ss format set-up.) and print it to another worksheet.
Believe it or not this all works fine if I have not filtered the list at all. Once I filter the list using any of the five criteria, the filter results come back with all entries.
I am using this code to filter by after making the selection.
Selection.AutoFilter Field:=2, Criteria1:=raloku.ListBox1.Value
Any ideas would be appreciated.