Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with code please
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.va lue=163,Rd1.value=165,Rd1.value=166,d1.value=168,d 1.value=169,d1.value170),""yes"",""no"")" Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with code please
I suggest using conditional formatting.
FormatConditional Formatting. Just build the formula you have here into the dialog box that comes up and you should be good to go. "Greg B" wrote: 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.va lue=163,Rd1.value=165,Rd1.value=166,d1.value=168,d 1.value=169,d1.value170),""yes"",""no"")" Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming | |||
stubborn Excel crash when editing code with code, one solution | Excel Programming |