Excel Userform-Check if line 3 is empty

I have a textbox on a userform in Excel for an address and the text is set to wrap, but I'd like to check if line 3 is empty. I've tried various method of extracting each of the lines to store them into variables, which I would later check, but none have worked. Could someone kindly point me in the right direction?

Thanks in advance.

Welcome to the forum!

Set the Multiline property to True, not Wordwrap, then use Split().

Please Login or Register  to view this content.

Thanks! I made a slight adjustment to use this as error validation:

s() = Split(Address_txt.Value, vbLf)
If UBound(s) + 1 < 3 Then
MsgBox ("Address must be a minimum of 3 lines. Please check your entry!")
End If

Is there a way to check line 3 for a space or carriage return? Sometimes pasting 2 lines will also add a carriage or empty space to line 3, which may fool the code above.

Thanks again!