Problems using Worksheet_Change

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does someone knows if exist any way of getting the old value in this:

Private Sub Worksheet_Change(ByVal Target As Range)
‘ for the new data coming is easy:
New_data = Target.Value

‘And about the old data into the cell…. Is there something like:

Old_data = Target.Old_data
End Sub

Thanks a lot
Peres
 
You will need to "remember" the old value by storing it in a static variable.
 
Tanks very, very much, you help me in 2 ways because I didnt know how to
create a variable that could be seen inside the subs...
Tanks again!
 
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

Worksheet_SelectionChange & Worksheet_Change results in different Targets 2
Trying to run excel vba code when cell value changes from empty to entered value. 1
Is it possible have a message ( visual or Audio ) when the Curser is place in a cell? 4
Macro converts time entered in column E and F from Indian time to CST( without daylight saving) 1
Junp start my Select Case Macro 12
Combine Two Different Worksheet_Change codes 9
hide multiple worksheets based on a formula value in one cell 1
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0

Back
Top