Excel VBA Lap Counter

Good day,

I am trying to make a race lap counter, for 100 participants. For each lap, I want to type the participant number, and when pressing enter, it should log the time, and be ready for the next number.
I have something similar, but with buttons - up to 30 participants. for 100, the buttons is getting overcrowded, and under pressure, it is difficult to log the correct participant number.

Does anyone have an example of how I could do it in VBA?

Thanks in advance

Johan

See the attached you may be able to adapt/expand the principle contained in this app.
The details of it's development are at the link below.

https://www.excelforum.com/excel-pro...ml#post5014041

Thanks for the quick help. I already have something similar, that can handle up to 30 laps. The problem is that I have to click on every riders name, or in my case, number. To handle 10 or 20 is okay, but we exceed 60 riders sometimes. The goal here is to use the keypad to enter the rider number to log his time. So every time a rider do a lap, the count and time is logged by entering his number with the keypad, and enter.
Attached my working example.

Thanks, appreciate