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
 
Back
Top