Loop in macro

**pdais97** · 09-16-2011, 05:03 AM

I have made a simple stopwatch with laps in excel with an macro.

Please Login or Register  to view this content.

As you see it is only made for two participants and I will need to make for about 100.
I was hoping to make a loop within the VB script so that I dont need to add 100 Sub Lapx
into the macro and also not to 100 Timesx and Nastax earlier.

Any idea´s?

**snb** · 09-16-2011, 06:08 AM

Please read the forum rules and add codetags around your code.

**pdais97** · 09-16-2011, 06:11 AM

Sorry about the tags. Now added.

**snb** · 09-16-2011, 06:34 AM

What triggers the macros to run ?

**pdais97** · 09-16-2011, 07:12 AM

I have a button to start recording (calling StartAll in macro).
Then I have a button for each participate to get the laps (calling Lapsx in macro).
I can supply the excel file if you want?