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

G

Guest

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
Number format of textbox in userform 3
Change Font color based on vaue 1
TextBox Color Red if Less than 50 3
Using a TextBox in a Userform 1
Number validation in Textbox using UserForm 1
Display Calculated amount in a textbox on userform 2
Change event for several Textboxes on UserForm 4

Top