Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple IFs
Thanks Tom, I think I found the error in some earlier
coding Bob -----Original Message----- Are you getting an error message or is the problem with the logic? What is Data, JValue etc? -----Original Message----- I cant seem to get this code to operate. Can anyone tell me why? If Frame5.OptionButton8.Value = True And Frame6.OptionButton12.Value = True Then If Data.Font.ColorIndex < 5 And JValue + KValue + LValue = 0 And MValue + NValue = 0 Then Data.Font.ColorIndex = 4 Thanks, Bob . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge multiple worksheets from multiple excel files into oneworksheet | Excel Discussion (Misc queries) | |||
Delete Blank Rows Code - Multiple Worksheets - Multiple Documents | Excel Discussion (Misc queries) | |||
Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
Display multiple lines of text within a cell from multiple column. | Excel Worksheet Functions | |||
view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) |