ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   OnAction? (https://www.excelbanter.com/excel-programming/333382-onaction.html)

Pixie

OnAction?
 
Hi,

I am trying to action a sub routine via a cell on a workbook - that is
whenever the cell is changed / activated a routine will be actioned.

Anyone got any ideas

Cheers

Dave

Anne Troy[_2_]

OnAction?
 
Hi, Pixie. This Sub is the perfect example of a worksheet_change event that
is activated by changing certain cell(s).
http://www.vbaexpress.com/kb/getarticle.php?kb_id=70
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Pixie" wrote in message
...
Hi,

I am trying to action a sub routine via a cell on a workbook - that is
whenever the cell is changed / activated a routine will be actioned.

Anyone got any ideas

Cheers

Dave




Dave Peterson[_5_]

OnAction?
 
Chip Pearson has lots of info on event procedures at:
http://cpearson.com/excel/events.htm



Pixie wrote:

Hi,

I am trying to action a sub routine via a cell on a workbook - that is
whenever the cell is changed / activated a routine will be actioned.

Anyone got any ideas

Cheers

Dave


--

Dave Peterson


All times are GMT +1. The time now is 04:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com