How to start a macro with a if statement

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

Guest

Hello there,

Do you know if it is possible to start a macro from an if statement? For
examle, if A1=foo, run macro1.

I am trying to hide a few rows when a given information is entered
 
Right click on your worksheet tab, select view code and paste this code into
the code window

Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Address = "$A$1" And .Value = "foo" Then Call macro1
End With
End Sub
 
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

Referencing a cell value in a macro 7
Macro Related to Paste Values 2
Macro with an IF/OR statement 10
pivot table macro with a filtering variable 3
hisind rows with an if statement 1
How to add text box with macro attached 1
Hiding Rows Using IF Statement 1
Can you use an IF statement to launch a macro? 3

Back
Top