Userform-Change textbox color and font based on input in other tex

N

Neal

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to change Userform Textbox Font attributes 3
TextBox Color Red if Less than 50 3
ActiveX Control changes font 0
drop down and textbox 1
Adding textboxes based on what user inputs in Total Students textb 0
Validations with messages in userform 0
Validate Textbox/Userform Number Range 2
Using a TextBox in a Userform 1

Top