Hi.
i have created a user form having 10 textboxes name tb1. tb2.....
i want to change background colour of text box,
when i enter , it becomes yellow,
when i change value of it, it changes to red
when i exit with no change it become normal colour..
how can i do it.
i have use code for enter.
Private Sub tb_EMPID_Enter()
Me.tb_EMPID.BackColor = vbRed
End Sub
but it change colour permanent after enter text box..
please give me solution or a way to solve this problem..
i have created a user form having 10 textboxes name tb1. tb2.....
i want to change background colour of text box,
when i enter , it becomes yellow,
when i change value of it, it changes to red
when i exit with no change it become normal colour..
how can i do it.
i have use code for enter.
Private Sub tb_EMPID_Enter()
Me.tb_EMPID.BackColor = vbRed
End Sub
but it change colour permanent after enter text box..
please give me solution or a way to solve this problem..