#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 221
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,758
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
UserForm OnAction Maria[_7_] Excel Programming 5 September 6th 04 08:56 PM
OnAction Variables Howiee22 Excel Programming 1 August 22nd 04 02:53 AM
.OnAction with arguments max Excel Programming 4 February 23rd 04 06:30 PM
OnAction Jim Rech Excel Programming 1 September 5th 03 04:39 PM
OnAction Richard Yang Excel Programming 1 July 15th 03 01:37 PM


All times are GMT +1. The time now is 10:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"