Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple IFs
it is unclear what Data is, but if it is the name of a control on a
userform, the it doesn't have a colorindex property. The color of a font on a control is done with the foreground color. Perhaps you could provide more details on what you mean by you can't get this code to operate. What line is highlighted? what is the error message. Regards, Tom Ogilvy "Bob" wrote in 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 | |||
Setting multiple conditions to return a figure from multiple cells | 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) |