| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing font color of textbox text.....
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing font color of textbox text.....
waht code are you running that gave you the error?
"jan" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing font color of textbox text.....
..font color=rgb(255,255,255)
"ben" wrote: waht code are you running that gave you the error? "jan" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing font color of textbox text.....
Use the forecolor property
-- Regards, Tom Ogilvy "jan" wrote in message ... .font color=rgb(255,255,255) "ben" wrote: waht code are you running that gave you the error? "jan" wrote: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing font color of textbox text.....
Hi Tom
Can you explain that with some code? thanks Jan "Tom Ogilvy" wrote: Use the forecolor property -- Regards, Tom Ogilvy "jan" wrote in message ... .font color=rgb(255,255,255) "ben" wrote: waht code are you running that gave you the error? "jan" wrote: 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing font color of textbox text.....
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 -- Regards, Tom Ogilvy "jan" wrote in message ... Hi Tom Can you explain that with some code? thanks Jan "Tom Ogilvy" wrote: Use the forecolor property -- Regards, Tom Ogilvy "jan" wrote in message ... .font color=rgb(255,255,255) "ben" wrote: waht code are you running that gave you the error? "jan" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Font color changing by itself | Excel Discussion (Misc queries) | |||
| Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
| Changing Font Color | Excel Discussion (Misc queries) | |||
| changing font color for new text | Excel Discussion (Misc queries) | |||
| Changing Font Color | Excel Programming | |||
Linear Mode
