Macro help please

[plchacker]

First I'll say hello. I'm short of time right now, but will be back
soon.

I do have a problem to solve. I'm trying to write a macro that
monitors a cell (W30) and then runs a sub when the value of the cell
changes to "1". The sheet will run 24/7, and so should the macro. The
value of the sheet will change via DDE link. I've tried macros that
detect a cell change in value, but they insist on the (enter) key.


Thanks for any help in advance. Gotta run, be back soon.

 

[Harald Staff]

Hi Busy Person

Try the calculate event -assuming that the change trigs a recalculation:

Private Sub Worksheet_Calculate()
If Range("W30").Value = 1 Then
Beep 'or whatever useful
End If
End Sub

 

[plchacker]

Thanks for the reply.

VB is not my strongpoint. I'll try your example and go from there.