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