Hi - how do you trigger a macro to run when a cell is updated in Excel?

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Windows Software section within the Tech Talk category of DaniWeb, a massive community of 423,005 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,856 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Windows Software advertiser: Programming Forums

Thread Tools Display Modes

Views: 2549 | Replies: 0

•

Join Date: May 2006

Posts: 1

Reputation: ben sellars is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

ben sellars ben sellars is offline

Offline

Newbie Poster

Hi - how do you trigger a macro to run when a cell is updated in Excel?

May 16th, 2006

Hi all,

I am new to this. I am just starting to use macros in Excel. I need to stamp the current date into a cell when any cell in a particular column is updated. I have a macro which will stamp the date in the cell for me but I can only trigger it to run with a key shortcut or at the press of a button (with macro assigned to it). Is it possible to trigger a macro to run when the contents of a cell are updated?

:rolleyes:

Any advice would be appreciated,

thanks

Ben