Userform search to return empty cells

Hi,

I need help with a vba code for a search userform that will return blank cells from a specific column depending on the search criteria, which is between months period (format mmmm/yyyy).

Columns in the spreadsheet should return the following:

Column C "Reference", Column E "Type" and Column W "Actions". (Not sure if display column W is necessary seeing as it is blank)

Column W named "Actions" is where I need to find if cells are blank and check what reference and type it belongs to.

Userform design is basic:

Month "combo box" Month "combo box"

"Text box" This I'm thinking will show the search results

"Search button" "Exit button"

I hope I've managed to explain that properly. I'm just really struggling with this one!

Quote from royUK

The simplest way would be to have userform with a ListBox holding the data which you can filter for blanks. Check this

Hi Roy,

That looks very good! But can you explain to me how that userform works? I tried using your attachment but couldn't see the filtered results.

Thanks

Virgil