PDA

View Full Version : Solved: Filter Records before sending to userform



MRichmond
02-13-2012, 07:44 AM
Good day to you all.

I have a workbook that contains a userform and a worksheet to hold the data user's enter.

Everything currently works as it should (thanks again XLD), but now I've been asked that instead of the userform displaying all records, it should only display records that have not yet been resolved (Column Y = "").

In the sample work book I would only see records 4,5 & 6 (rows 5-7) when I scroll through the records.

Does anyone know how I can modify the existing code to achieve this please?

Thanks in advance for the help

Bob Phillips
02-13-2012, 08:45 AM
Try this

MRichmond
02-14-2012, 01:53 AM
Thanks XLD,

I was confused at first, as the records I didnt want to see were the only ones I could see, but I was able to figure out where the change needed to be made and now it works great.

Thanks again for you assistance.

Bob Phillips
02-14-2012, 01:59 AM
Oops, yes I showed the resolved ones didn't I :(

MRichmond
02-14-2012, 02:02 AM
Hey no problem, at least this time I was able to see how to fix it myself.
:beerchug:

Bob Phillips
02-14-2012, 03:20 AM
Did you test it for blank or not equal Yes?

MRichmond
02-14-2012, 07:27 AM
I tested for Blank, and made the field either Yes or blank entry.