Run macro as selected cell changes

  • Thread starter Thread starter Maria
  • Start date Start date
M

Maria

Hello: Would appreciate help with this one.

Cell A1 has a drop down list (using Data Validation feature of Excel). As
value of A1 is changed I want a number of things to happen (which are
recorded in a macro) such as clear content of some cell, enter values in
others etc. Thus as cell A1 value is changed I want a macro to run.

(Note: the changes I want cannot all be accomplished by formulas alone, and
hence I want the macro to run when selection in A1 is changed)

TIA
 
Right-click the sheet tab, select View Code, enter this
Private Sub Worksheet_Change(ByVal Target As Range
If Target.Address = "$A$1" The
'your code her
End I
End Su

----- Maria wrote: ----

Hello: Would appreciate help with this one

Cell A1 has a drop down list (using Data Validation feature of Excel). A
value of A1 is changed I want a number of things to happen (which ar
recorded in a macro) such as clear content of some cell, enter values i
others etc. Thus as cell A1 value is changed I want a macro to run

(Note: the changes I want cannot all be accomplished by formulas alone, an
hence I want the macro to run when selection in A1 is changed

TI
 
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

Run Macro If Cell have "x" value 0
Run two macros for two different sheets 11
Make Macro Work On A Different PC 5
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Referencing a cell value in a macro 7
Altered pasting functionality 3
Certain string in cell A1 causes a change in Cell B1 7
Macro command to move cell selection 3

Back
Top