Changing font color of textbox text.....

[Guest]

Hi all,
I've a textbox on the userform that's shows the names of all the files
openend by my vba code.
Now I will change the font color when file x is open(i.e.on the j: drive) or
when file y is open(i.e on the c:drive) the font color must change to another
color.
I got an error message 438 when running the code.
Is there a solution for this?
Kind regards
Jan

 

[Guest]

waht code are you running that gave you the error?

 

[Guest]

..font color=rgb(255,255,255)

waht code are you running that gave you the error?

 

[Tom Ogilvy]

Use the forecolor property

 

[Guest]

Hi Tom
Can you explain that with some code?
thanks Jan

 

[Tom Ogilvy]

Assuming a textbox on a userform:

Private Sub CommandButton2_click()
TextBox1.BackColor = RGB(0, 255, 255)
If TextBox1.ForeColor = RGB(255, 255, 255) Then
TextBox1.ForeColor = RGB(255, 0, 255)
Else
TextBox1.ForeColor = RGB(255, 255, 255)
End If
End Sub