AlphaDog and Others,
Had to remove the follow from the code
as the example I posted may have been a bit misleading as the next step in using this filter was to write data to a sheet, therefore the "sDate" field on the userform was not intended to change. Not a problem as code filters data that I'm looking to return.
In incorporating with the master file I did run into a bit of a hiccup though when writing to the sheet through a "enter" button. The return price based on the code you supplied is not written to the sheet where the filter was applied but a second sheet with additional data field values that did not appear on form in test file.
I think I have been having this problem when I attempted to run macros from a combobox change event and then clicking an enter button where the data is written to the table okay, but you cannot clear the combobox field in the "click" event or an error occurs in line
.
It is like it loops back because if you clear the combobox it appears to be equivalent to a change event. Ideally, I'd like to clear the combobox after the click event if this is possible. Even if I set autofilter to off in your code, the looping still occurs in the "click" event unless I do not clear the combobox value in the "click" event.
Is it possible to clear the combobox field in the "click" event without looping back into the filter and getting ack into and hung up on the line of code above?
TIA
Bookmarks