• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

question, I don't want the second msgbox activated.

Belleke

Well-Known Member
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target, Range("A1")) Is Nothing Then
    MsgBox "Maak eerst je keuze in cel A1", vbExclamation, "Cel A1 is leeg"
End If
End Sub
 
What second message box? Do you mean if you select A1 more than once?

If you mean you only want to see it once per session, you could use a static variable. If you mean you only want to see it once ever, you'd have to store a value somewhere that you can check, eg in a named range, registry, text file, etc.
 

Belleke

... seems You haven't.
This my sample works other way.
Did You miss to explain - how something should work?
 

Attachments

  • leeg.xlsb
    13.5 KB · Views: 2
Back
Top