ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macros (https://www.excelbanter.com/excel-programming/291031-macros.html)

Adam Harris

Macros
 
Hi,

I am having a problem with my macros. I want to run two,
on the same worksheet, but it is not happening. Quite
simply:

Macro/Command 1 - Start (A1=NOW)
Macro/Command 2 - Stop (B1=NOW)
Calculation - C1=B1-A1 = Duration

I wanted to put the macros into a command button, and I
can get one or the other to work, but not both.

The recorded code for each macro and associated command
code is either Command_1 or Command_2. When I change the
parameter for one, the other changes too, almost like a
shadow.

Please help.

Thanks.


All times are GMT +1. The time now is 02:18 AM.

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