restrict a search to either text entries or date entries when loading dynamic userform

The attached workbook loads data from a named range in a worksheet "BNM" and when there was only date entries the rows included in the count to size the userform worked correctly and restricted the row number to just the dates ignoring blanks for every column in the named range tblEmployeeData9

It is now required to have a seperate userform which would display who has not been inducted to a site

I tried setting the Isdate to look for blanks instead but then it counted every blank row. To restrict it to the relevant column I added "no". This works fine.

Click Bord na Mona and the list of inducted is shown - close and then select checkbox before click again and the "no's" are shown

AS you can see by the message box though, the row count is counting for every cell with an entry, whether date or text, and making the form too large

Any ideas to restrict the criteria to count JUST dates or text entries so the row count is correct

Load code is in userform F18_BNM "Create labels" and area to focus on is yellow in worksheet "BNM"

Any ideas most appreciated, in code you will see I've tried a few things

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I found that changing the line to check for a date now gives the correct row number for the userform, however if Option button two was selected in would have to change to

Please Login or Register  to view this content.

Thought I had it with changing the Function to

Please Login or Register  to view this content.

But second case option is returning a row for the text entries and The blank entries not just the text