Hi all
I have a question about the most efficient and effective way of doing the following:
I have created something in VBA that logs lap times etc. for a computer racing game. There are 10 races in total (each race has its own userform) that have lap times, the date the time was set, and the driver's name (three people are available). Each of these 10 races provides the option of 'Update Name' to allow me to select the person (of the three total) who completed that particular fastest lap.
The listbox (which contains the three names) is part of another userform which is shown when 'Update Name' is pressed. Then, when a name is selected, the relevant 'Driver Name' box is filled out on that particular race's userform. However, unless I create 10 separate 'Driver List' userforms (each containing a listbox with the three names), I don't see how I can get VBA to know which Driver Name box to fill out (because in the driver list userform, I need to tell it which race's 'Driver Name' textbox to fill in).
I have a solution using a cell in Excel as a reference, but I'm not happy with that, as I feel there's something in VBA which can do this (without creating 10 separate 'Driver List' userforms).
Hopefully that makes sense -- I haven't included code because there isn't really much I can offer when I don't know what the code would be!
Thanks in advance.
Bookmarks