can you change the filter criteria of a worksheet based on the value of a combobox on a userform?
Example:
I have a worksheet that has two columns of data. In column A, I have three different entries, completed, pending, & paused. In column B, I have just misc tasks. I have filtered the worksheet based on column A. Is there a way that when select one of the three column A criteria in combobox1 on my userform only the data that matches that criteria in column B displays in listbox1??
This message was edited by VTTW on 2002-03-25 19:33
Example:
I have a worksheet that has two columns of data. In column A, I have three different entries, completed, pending, & paused. In column B, I have just misc tasks. I have filtered the worksheet based on column A. Is there a way that when select one of the three column A criteria in combobox1 on my userform only the data that matches that criteria in column B displays in listbox1??
This message was edited by VTTW on 2002-03-25 19:33