Thread: How do get a macro to autorun when i change a cell in the spreadsheet?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Infinity Infinity is offline
external usenet poster
  
Posts: 1
Default How do get a macro to autorun when i change a cell in the spreadsheet?

Let say Cell "A1" has only 2 values that is Purchase or Sales.

Now when i change this cell to either value, i want it to run a macro

e.g.
When i change Cell to "Purchase" i want to autorun Macro A
And
When i change Cell to "Sales" i want to autorun Macro B

How do i do this? And it is for a particular worksheet only.

Thanks in advance.


--
Infinity
------------------------------------------------------------------------
Infinity's Profile: http://www.excelforum.com/member.php...o&userid=32725
View this thread: http://www.excelforum.com/showthread...hreadid=526617

Reply With QuoteReply With Quote