donny1shot
New Member
- Joined
- Mar 8, 2018
- Messages
- 18
Hi all I am currently running the code below. However the bottom part runs before I am able to complete filling in the relevant cells so it prints the sheet to quickly. How can I stop this.
Thanks in advance.
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("C12").Value = "Yes" Then MsgBox prompt:="Please make SOP aware!", Title:="CAUTION!"
If (Range("F15").Value) > Range("C13").Value Then UserForm1.Show
If (Range("F15").Value) < Range("C13").Value Then ActiveSheet.PrintOut
End Sub
Thanks in advance.