Feb 05 2023 07:23 AM
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
Userform.Show
End If
End Sub
Feb 06 2023 03:10 AM