| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform-Change textbox color and font based on input in other tex
Dear Excel Programming People,
I have a userform with multiple textboxes. I have textbox A where the user inputs a number. If the number is higher than 50, I want textbox B to show that number in red and bold, but if the number is less than 50, I want textbox B to show the number in black and normal font. I have it where it becomes red (ComputeBox.ForeColor = 255), but cannot get it to be bolded. What is the code for that? Thanks in advance. Neal |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform-Change textbox color and font based on input in other tex
Hi Neal
Me.TextBox1.Font.Bold = True -- Regards Ron de Bruin http://www.rondebruin.nl "Neal" wrote in message ... Dear Excel Programming People, I have a userform with multiple textboxes. I have textbox A where the user inputs a number. If the number is higher than 50, I want textbox B to show that number in red and bold, but if the number is less than 50, I want textbox B to show the number in black and normal font. I have it where it becomes red (ComputeBox.ForeColor = 255), but cannot get it to be bolded. What is the code for that? Thanks in advance. Neal |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform-Change textbox color and font based on input in other
Ron,
Thanks. It works perfectly. Neal "Ron de Bruin" wrote: Hi Neal Me.TextBox1.Font.Bold = True -- Regards Ron de Bruin http://www.rondebruin.nl "Neal" wrote in message ... Dear Excel Programming People, I have a userform with multiple textboxes. I have textbox A where the user inputs a number. If the number is higher than 50, I want textbox B to show that number in red and bold, but if the number is less than 50, I want textbox B to show the number in black and normal font. I have it where it becomes red (ComputeBox.ForeColor = 255), but cannot get it to be bolded. What is the code for that? Thanks in advance. Neal |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change font color based on a value | Excel Worksheet Functions | |||
| How to change Font size based upon cell input | Excel Discussion (Misc queries) | |||
|
How do you change font color based on the value input? 1 = |
Excel Discussion (Misc queries) | |||
| Change Font Color Based on Classification | Excel Discussion (Misc queries) | |||
| Browse Forms Controls and change TextBox color based on cell color | Excel Programming | |||
Linear Mode
