texbox auto color based on value

R

ryan_law2000

Well-known Member
Joined
Oct 2, 2007
Messages
738
In a userform i have a label1 saying "ALERT" and is hidden

How can this be shown when:
textbox1= any number in column B Sheet1

Then when textbox1 is changed to a number not shown in column B Hide Label1
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Sort by date Sort by votes
What code do you have so far?

Are the numbers in column B actual numbers? Or are they text entries that look like numbers?
 
Upvote 0
You must log in or register to reply here.

Similar threads

H
  • Question Question
Userform Help
Replies
5
Views
355
Hjemmet
H
I
  • Solved
Show or Hide Textbox advice
Replies
8
Views
653
dmt32
D
I
  • Question Question
Have the code select the cell that relates to what was searched for
Replies
0
Views
227
ipbr21054
I
I
  • Solved
Unable to change textbox name without code breaking
Replies
6
Views
289
ipbr21054
I
K
  • Question Question
I was try to load data To List Box And Transfer data to Sheet2.... (Not work this userform)
Replies
4
Views
222
krunal123
K

Forum statistics

Threads
1,224,522
Messages
6,179,299
Members
452,904
Latest member
CodeMasterX

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top