Hi all,

I have a userform with some text boxes, and I want one of them to be
grayed out depending on the entry in the one before it. If the user
types "FL" in the first box, I want the second to be disabled. The
trouble is that I want it to check this after the entry in the first
box is made and while the userform is still up.

How do I make it happen after the entry is made? It would also work if
I could make it happen upon tabbing out of the box or into another.
Here's the code I'm trying:


Private Sub txtFee_Change()
'grays out the fee box if txtState = FL
If txtState = "FL" Then
txtFee.Enabled = False
Else: txtFee.Enabled = True
End If
End Sub


This code is fine and works for graying out, but only if the txtState =
"FL" at initialization. I want it to work right when FL is entered.

Thanks for your help!


--
Lost!
------------------------------------------------------------------------
Lost!'s Profile: http://www.excelforum.com/member.php...o&userid=23990
View this thread: http://www.excelforum.com/showthread...hreadid=385312