I have three text boxes in a form. As soon as I enter a character in one
of the textboxes, the other two should be disabled. If I then delete
whats in that textbox, so it is 'empty' again, the other textboxes
should be enabled again.

What should I do?


---
Message posted from http://www.ExcelForum.com/

Private Sub TextBox1_Change()
TextBox2.Enabled = (TextBox1.Text = "")
TextBox3.Enabled = TextBox2.Enabled
End Sub


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"anb001 " wrote in message
...
I have three text boxes in a form. As soon as I enter a character in one
of the textboxes, the other two should be disabled. If I then delete
whats in that textbox, so it is 'empty' again, the other textboxes
should be enabled again.

What should I do?


---
Message posted from http://www.ExcelForum.com/