starting a macro

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

How can I have a macro run as soon as someone imputs information into a cell
from a drop down box.

cell("B9")=4062 ~~~> as soon as they leave this cell I want it to run a
macro called "Populate Graphs". "Populate graphs will be a case select
macro.

The key here is to get the macro to start when ever they leave cell B9

Eric
 
Paste this code directly into the sheet (right click the sheet taba an select
view code).

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$9" Then Call PopulateGraphs
End Sub
 

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

Macro running automaticly 1
macro 4
Cells Left Blank 3
macro to run IF condition met 9
Pasting Variable cell info into a macro 1
Pasting cell contents into a macro 1
Help in adding another check to my code 1
Advice on multiple macros, same code just a different column 9

Back
Top