Hello,

I have a USERFORM with lots of objects (textboxes, dropdowns, etc.). I also have a "locked" OK button that I want to activate only if everything is filled properly.

How can I check that? I need some sort of event that will take place each time something changes so I have:

Sub USERFORM_EVENT()
if ALL DATA IS FILLED CORRECTLY Then Button.Enabled = True Else Button.Enabled = False
End Sub

Thanks,

Yona