ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multiple IFs (https://www.excelbanter.com/excel-programming/271596-multiple-ifs.html)

bob

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
.

.



All times are GMT +1. The time now is 01:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com