VBA Error Handling

[ItalianPlatinum]

I thought this would be an easy find but I am actually having trouble finding a way to accomplish this. I am looking for a way pop a warning message if someone ran the VBA sub already. Essentially I have a file and only want my PRE work run once only and if a user tries to run it a second time I want an error message to display to sort of slow them down like are you sure you want to run this it was already run. I couldnt find anything via google searches. Someone able to help?

 

[ItalianPlatinum]

The only modification was if it does meet I do want the user to have the ability to still proceed.

 

[Joe4]

You could do something like this:

Dim chk
If Int(Range("Z1")) = Date Then
    chk = MsgBox("You already ran this today, do you still want to continue?", vbYesNo)
    If chk = vbNo Then
        Exit Sub
    End If
End If

If they click "No" it will exit the sub, otherwise it will continue.

 

[ItalianPlatinum]

Awesome! works good.