Forum Discussion
Anthony Smith
Oct 04, 2018Brass Contributor
Excel VBA Worksheet Change Event Causes Message Box to Appear Multiple Times
Hello, The below code checks to ensure a certain cell has a value before changing the color back to the sheet's original color. By changing the color from yellow to the sheet's original color, th...
Lorenzo Kim
Oct 05, 2018Bronze Contributor
the event change is detecting any alteration made in a sheet. so every time you make a change - the msgbox will pop up no matter where you place the code. if you delete it, then the only change will be the color.