Executing a macro command

[Salza]

How do I execute a macro command by just typing something in a cell?
For example, when a user type letter Y in cell A1.. macro 1 will
execute, then when he types letter B also in cell A1, the second macro
will execute and so on. Thank you.

 

[Harald Staff]

There is an event macro that runs when you change a cell value, the
worksheet_change macro, make that macro decide which macro to call and do
it.

See http://www.cpearson.com/Excel/Events.aspx

HTH. Best wishes Harald

 

[Salza]

There is an event macro that runs when you change a cell value, the
worksheet_change macro, make that macro decide which macro to call and do
it.

Seehttp://www.cpearson.com/Excel/Events.aspx

HTH. Best wishes Harald

Thank you, Harald. I will read it and try it out.