Activate macro based on cell value

  • Thread starter Thread starter LB79
  • Start date Start date
L

LB79

I want to have a macro that constantly plays in the background lookin
for a change in a cell value. When the cell value changes a secon
macro activates. So far i have this but its not really working

can anyone help?

Sub Auto_Open()

Do

If Range("C1") > ("0") Then
Application.Run "'Workbook.xls'!Macro"
Else
Exit Sub
End If

Loop

End Su
 

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

Run Macro If Cell have "x" value 0
After Macro runs, no cell activated - what am I missing? 2
Pasting cell contents into a macro 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Macro Pause for selecting cell 3
Runtime Error '91' Object variable or With block variable not set 2
Trying to run excel vba code when cell value changes from empty to entered value. 1
Paste values for entire row based on cell contents 8

Back
Top