Worksheet_Change

  • Thread starter Thread starter Rasmus
  • Start date Start date
R

Rasmus

I have the following sub to determine whether another sub should be run:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 5 And Range("e" & Target.Row) <> "" Then
MsgBox ("This line qualifies for the sub!")
' Call the sub
End If
End Sub

Is there a way to only run the sub if target is CHANGED from 0 to something
that > 0 ?

Rasmus
 
Only if you store the values of Column E and then compare the appropriate
value to the current value.
 
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

Change_Event not responding to change made by formula. 11
Macro converts time entered in column E and F from Indian time to CST( without daylight saving) 1
Excel Worksheet_change with 2 functions to insert date and hyperlink window 0
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Worksheet_SelectionChange & Worksheet_Change results in different Targets 2
If cancel list box don't enter FALSE in list 2
Is it possible have a message ( visual or Audio ) when the Curser is place in a cell? 4
Trying to run excel vba code when cell value changes from empty to entered value. 1

Back
Top