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

  • Thread starter Thread starter serdar
  • Start date Start date
S

serdar

Private Sub Worksheet_Change(ByVal Target As Range)

If (expression) Then
Application.Undo


End Sub


This works but a flashing occurs. What to do?
 
....no flashing occurs at all. I'm not gonna ask "too fast questions" again,
sorry :)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to run excel vba code when cell value changes from empty to entered value. 1
help with restricting paste in cells with data validation 1
Is it possible have a message ( visual or Audio ) when the Curser is place in a cell? 4
Unprotect Sheet for the duration of a script 7
Search for LIKE 4
error 13 2
Macro Stoped Working 2
Excel Target.column for Data Validation would like to target some cells within column 1

Back
Top