Undo change

  • Thread starter Thread starter Bhuktar S
  • Start date Start date
B

Bhuktar S

Can anyone help to let me know how do to allow user to undo the chang
in a cell which has been conditioned through VBA?
For example, as in below, after the user changes the value in cel
(2,12), it cannot be undone to make it unchanged. The user needs t
re-enter the old value again.
I do not want to add a macro button for formatting the number.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Cells(2, 12).Value < 100 Then
Cells(2, 12).NumberFormat = """AW10""0"
Else: Cells(2, 12).NumberFormat = """AW1""0"
End If
End Su
 
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

Time stamp with undo funktion 2
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Date Stamp in Last Column in active row if any data changes in row 1
array data type issues - 11
auto running macro 2
Returned position address on protected sheet 7
Time issues in code 6
Place a date in another cell only if adjacent cell = "X" 1

Back
Top