Help with code please

G

Greg B

I have a text box that cant have the values 1 , 159, 162, 163, 165, 166,
168, 169 or anything above 170

I have written a code which changes the number into a red number if it is
wrong but the problem is when it checks the next number in the series it
converts the error back to black.

is there a way to get it to check for all of the numbers in one swoop
here is the code using the recorder but i need to change it to suit
d1.textbox
"=IF(OR(d1.value=1,d1.value=159,d1.value=162,d1.value=163,Rd1.value=165,Rd1.value=166,d1.value=168,d1.value=169,d1.value>170),""yes"",""no"")"
Thanks
 
M

Mike H.

I suggest using conditional formatting.

Format>Conditional Formatting. Just build the formula you have here into
the dialog box that comes up and you should be good to go.
 

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

Code to insert a coma 26
simple code but it doesn't look like usual vba code 2
Excel - eliminating repeated data 3
Help with IF statement check value in multiple cells 1
VB CODE REQUIRED..........HELP PLEASE 2
text manipulation in change event 3
Help with Code 5
Help with using custum functions 2

Top