The macro below works but it seems the msgbox only appears when I physically run the macro. Is there a way the msgbox will appear automatically as soon as K100 meets the proper condition, OR when the excel file is opened? Also I may open this file 10 times while the first condition is met. Will the msgbox appear each time, or can it be programmed to appear only once for each condition?
If k100 >= 50 And k100 < 75 Then
MsgBox "50% Complete"
ElseIf k100 >= 75 And k100 < 89 Then
MsgBox "75% Complete"
ElseIf k100 = 90 Then
MsgBox "90% Complete"