belsha
10-28-2003, 05:45 AM
I have a macro that looks at 3 fields,
4a, 4b, and 4c. If 4a=6 & 4b =6 then the total field (4total) shows the message "You have entered 2 sixes, no calculation will be done." and fills in a 0. Great. However, if I then go to do that for 4b=6 & 4c=6, then it still calculates the 0, but can't get the msgbox to show any message. These are done in separate sections in the macro (first part of macro looks at 4 a & b, next looks at 4 b&c, last looks at 4a & c). All calculate fine, just the msgbox on part 2 and 3 doesn't appear. Any suggestions?
4a, 4b, and 4c. If 4a=6 & 4b =6 then the total field (4total) shows the message "You have entered 2 sixes, no calculation will be done." and fills in a 0. Great. However, if I then go to do that for 4b=6 & 4c=6, then it still calculates the 0, but can't get the msgbox to show any message. These are done in separate sections in the macro (first part of macro looks at 4 a & b, next looks at 4 b&c, last looks at 4a & c). All calculate fine, just the msgbox on part 2 and 3 doesn't appear. Any suggestions?