Thread: Multiple IFs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bob bob is offline
external usenet poster
 
Posts: 1
Default 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
.

.