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