+ Reply to Thread
Results 1 to 2 of 2

How to validate and -if invalid- undo an entry?

  1. #1
    serdar
    Guest

    How to validate and -if invalid- undo an entry?

    Private Sub Worksheet_Change(ByVal Target As Range)

    If (expression) Then
    Application.Undo


    End Sub


    This works but a flashing occurs. What to do?



  2. #2
    serdar
    Guest

    Re: How to validate and -if invalid- undo an entry?

    ....no flashing occurs at all. I'm not gonna ask "too fast questions" again,
    sorry

    "serdar" <[email protected]>, haber iletisinde şunları
    yazdı:[email protected]...
    > Private Sub Worksheet_Change(ByVal Target As Range)
    >
    > If (expression) Then
    > Application.Undo
    >
    >
    > End Sub
    >
    >
    > This works but a flashing occurs. What to do?
    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1