textbox enabled

[Jaye7]

Hi All,

I set the value of textbox1.enabled=false on my userform.

Is there a way that I can set the forecolor font to black so that the text isn't faded out.

I have tried setting the textbox1.forecolor=&H80000008& but it remains faded, as obviously the textbox is not enabled.

I don't want people to be able to enter the textbox but I want the font to remain dark, not faded out.

If you could help with my other post also it would be much appreciated.

http://www.mrexcel.com/forum/showthread.php?t=539178

 

[Jaye7]

I have found a way to get around this problem.

I have a textbox which I set the tag to B, when the textbox tag equals B then the script redirects as follows.

textbox30.tag="B"
 
 
Private Sub TextBox2_Enter() ' this script for all relevent textboxes
If TextBox30.Tag = "B" Then
TextBox1.SetFocus
End If
End Sub

only when I click on my commandbutton to Modify will it give me access to the textboxes as the commandbutton changes the textboxes tag to H.

then when I click on my Save commandbutton or Cancel commandbutton it then resets textbox30.tag to "B" so that if they try and click on the textboxes it then redirects again.

I managed to work something out for myself for a change.