Show Userform when cell value reached

Copper Contributor

Hi all.

I want a userform I've created to pop up when a cell reaches a value from the formula, e.g. when the cell value reaches 0, the userform will pop up. The userform has a button that takes the user to another worksheet.


So far, I can make the userform appear, the button takes you to the next worksheet, but the userform will not go away. I assume this is because the cell value that triggers it is still 0. How can I stop this from happening?


Here is the code I've used:


Private Sub Worksheet_Calculate()
     If Sheets("Sheet1").Range("v3") = 0 Then
     End If
End Sub

1 Reply


Here is an example (inserted as a file) from the Internet, unfortunately I don't know where it came was a long time ago.
Maybe it will help you :).