Archive of Mr Excel Message Board
Back to Dates in Excel archive index
Back to archive home
activating macro within a cell formula
Posted by J-funk on June 22, 2001 7:23 AM
How would one activate a macro inside of a cell formula... you know, activate this macro if this is this... help me out!
Re: activating macro within a cell formula
Posted by Dax on June 22, 2001 7:31 AM
If you want to run a macro based on certain cell conditions being true or false then you can use worksheet events. Right click the sheet tab, click View Code. You'll see the worksheet code module. In the left hand combo box choose Worksheet. In the right hand combo box choose Change. You can then write code that will be activated each time a user changes a cell value and then check for various conditions. Make sense? If not, post some more details of your particular problem.
Regards,
Dax.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.