ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Recording macro usage (https://www.excelbanter.com/excel-programming/426207-recording-macro-usage.html)

LiAD

Recording macro usage
 
Hi,

is there the functionality in excel to record when a macro form button is
pushed?

I have, or will have a sheet with about 20 macros on it, all of which
perform simple + and - operations. I would like excel to record which macro
(by the macro name), the date and time at which any button was pushed, just
in one big long list one after another.

Is this possible?

Thanks


Daniel

Recording macro usage
 
yes, set up a sheet or file for the capture. in each button code send the
date and button name to the location/

"LiAD" wrote:

Hi,

is there the functionality in excel to record when a macro form button is
pushed?

I have, or will have a sheet with about 20 macros on it, all of which
perform simple + and - operations. I would like excel to record which macro
(by the macro name), the date and time at which any button was pushed, just
in one big long list one after another.

Is this possible?

Thanks



All times are GMT +1. The time now is 10:35 AM.

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