Hallo EVERYBODY!

Is there any way to handle all form's events in one procedure?

i'd tried to handle UserForm_OnKeydown event - but it's not fired.

I tried to use Application.OnTime, it works, but its not acceptable (too risky, at least 1 second latency):

here is the code:

Public Sub RegisterFormHandler(f As UserForm)
Set m_UserForm = f
Application.OnTime Now + TimeValue("00:00:01"), "FormHandler", Now + TimeValue("22:00:01")
End Sub

Public Sub FormHandler()
RefreshFormState m_UserForm
Application.OnTime Now + TimeValue("00:00:01"), "FormHandler", Now + TimeValue("22:00:01")
End Sub

What i want is to run FormHandler (exacly RefreshFormState...) proc every time user presses a key (common OnChange event)
RefreshFormState (its ready) iterates through all form's controls and handles all validation, conditional-enable/disable etc.

Anybody know how to do it?

Excel 97 solutions required!