Hi, I have a listbox on a form that i would like to dynamically set the row source on. I have 3 option buttons on same form, Opt1, Opt2, OptFull. I'm using a combo box (CMBStaff) change event to fire the code, the appropriate table on sheet1 is found using this combo box selection. The first column of the table that is found has dates. The table data is created with formula and is always sorted in chronological order (Oldest dates first). If Opt1 is selected, I would like to see only items with dates less than a specific date - sheet4.range("A17"), if Opt2 is selected, I would like to see only items with dates more than a specific date - sheet4.range("A16"), and if OptFull is selected, the code I have works for that.
I hope this isn't too convoluted, I commented the code below, that may be more helpful than the paragraph I've written above.
Bookmarks