Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox font color change (update, but still not quite there)
I just recently posted this question, and I've almost got it figured
out, but not quite. I have a form with a text box called textNotes. The notes that are entered into this text box on the form get added to a spreadsheet to update a 'notes' cell that is entered into a variable name called 'myNotesRange' for a given report number. The value in the myNotesRange gets put into a variable called myNotesValue. I want to have the color of the text that gets added to the spreadsheet be red. I was shown code to do this, and I think I'm close, but I'm still getting an error message stating "Unable to set the Text property of the Characters class". Here's what I have. With Range(myNotesRange) With .Characters(Len(myNotesValue) + 1, _ Len(textNotes.Text)) .Text = textNotes.Text ' this is where debug message shows .Font.ColorIndex = 3 End With End With Thanks for any (continued) help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox font color change (update, but still not quite there)
try this. I moved .value up in the code. Also had to change from .text to
..value. With Range(myNotesRange) .Value = textNotes.Text With .Characters(Len(myNotesValue) + 1, _ Len(textNotes.Text)) .Font.ColorIndex = 3 End With End With "Phrank" wrote: I just recently posted this question, and I've almost got it figured out, but not quite. I have a form with a text box called textNotes. The notes that are entered into this text box on the form get added to a spreadsheet to update a 'notes' cell that is entered into a variable name called 'myNotesRange' for a given report number. The value in the myNotesRange gets put into a variable called myNotesValue. I want to have the color of the text that gets added to the spreadsheet be red. I was shown code to do this, and I think I'm close, but I'm still getting an error message stating "Unable to set the Text property of the Characters class". Here's what I have. With Range(myNotesRange) With .Characters(Len(myNotesValue) + 1, _ Len(textNotes.Text)) .Text = textNotes.Text ' this is where debug message shows .Font.ColorIndex = 3 End With End With Thanks for any (continued) help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Textbox font colour change? | Excel Discussion (Misc queries) | |||
How to have textbox font color change? | Excel Programming | |||
Userform-Change textbox color and font based on input in other tex | Excel Programming | |||
Changing font color of textbox text..... | Excel Programming | |||
Browse Forms Controls and change TextBox color based on cell color | Excel Programming |