Greying out the OK button

[Jeff M]

I have a form that my users fill out. I want the OK button greyed out
until they fill out the form perfectly. At this point, I have
simplified it down to the following:

Private Sub UserForm_Activate()
btnOK.Enabled = False
End Sub

Private Sub txtEnd_AfterUpdate()
If Not IsNull(txtStart) And Not IsNull(txtEnd) Then
btnOK.Enabled = True
End If
End Sub

The problem is the OK button disables fine, but it never enables. When
I step through the code, it enables. Its like the code doesn't have
enough time to "darken in" the OK button, so it skips it unless the
slow human is doing the processing.

What I am doing wrong?

 

[Guest]

I tested out your code as written and it worked fine for me. Excel 2000 on
Win 2000.

 

[Jeff M]

Hmmmm. I have Excel 2000 on W2K as well. I just checked and I have
Office 2000 original issue (never been patched). I think I'll patch it
and try again.

 

[Jeff M]

Well, I patched Office and Windows and still no go.

 

[Tom Ogilvy]

I can't explain your problem, but your next problem will be with using
ISNULL.


? isnull("AA")
False
? isnull("")
False

It will always return false unless you have a true NULL (not empty string)
in the cell.

 

[Tushar Mehta]

Instead of disabling the OK button until the form is filled in
correctly, use it to validate the contents of the form.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jeff M]

Yes, that's what I'm going to have to do. I'll mess around with
colored fonts, etc. Oh well.