Method or Data Member not Found

See more:

MS-Excel

VBA

Hi Everyone,

I'm trying to validate all text boxes in my form if there are blanks. but i'm getting "Method or Data Member not Found" Error

Here is the code:


Dim ctl As Control

For Each ctl In Me.Controls'
If TypeName(ctl) = "TextBox" Then
If ctl.Value = "" Then
msg = MsgBox("All Fields Required", vbExclamation + vbOKOnly + vbApplicationModal, "Warning")
Exit Sub
End If
End If
Next ctl

The <Me.Controls> on my first line gets highlighted with error.
not not sure if i had missed to add a reference like ActiveX Control under Tools > References.

thanks in advance.