How do I get the old value of a changed cell in Excel VBA?

by

try this

declare a variable say

Dim oval

and in the SelectionChange Event

Public Sub Worksheet_SelectionChange(ByVal Target As Range)
oval = Target.Value
End Sub

and in your Worksheet_Change event set

old_value = oval

More Related Contents:

  1. How do I get values from a hidden worksheet using VBA [closed]
  2. How to copy cells that contain certain text to another worksheet [closed]
  3. VBA Macro for copying and pasting columns on same excel sheet
  4. Excel VBA, code to count the # of filled cells, then find highest and 2nd highest and subtract the corresponding column #’s [closed]
  5. Levenshtein Distance in VBA [closed]
  6. Unprotect VBProject from VB code
  7. Can VBA Reach Across Instances of Excel?
  8. Excel VBA – Delete empty rows
  9. Efficient way to delete entire row if cell doesn’t contain ‘@’ [duplicate]
  10. Building Undo Into an Excel VBA Macro
  11. Excel vba add code to sheet module programmatically
  12. Best workaround for VBA Transpose array length limit?
  13. How to Lock the data in a cell in excel using vba
  14. How to use Events with Option Button Controls on Userform [duplicate]
  15. How do I use variables to set properties in VBA (Excel)
  16. VBA: Else without If Error
  17. Workbooks.Open Method in VBA
  18. Windows().Activate works on every computer except one
  19. How to highlight a cell using the hex color value within the cell?
  20. Convert RTF (Rich Text Format) code into plain text in Excel
  21. lastrow and excel table.
  22. Open a workbook from VBA and disable Workbook_Open() code?
  23. Creating form programmatically in the module using vba
  24. What are the differences between using the New keyword and calling CreateObject in Excel VBA?
  25. How to filter listbox values based on a Textbox value
  26. Find and FindNext for Excel VBA
  27. Meaning of .Cells(.Rows.Count,”A”).End(xlUp).row
  28. How do I get a list of unique values from a range in Excel VBA?
  29. How to get selected value in multicolumn listbox
  30. Query my excel worksheet with VBA

Leave a Comment