Disable textboxes
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/ |
Disable textboxes
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/ |
All times are GMT +1. The time now is 05:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com