CAR RACING USING VBA

%3CLINGO-SUB%20id%3D%22lingo-sub-2381077%22%20slang%3D%22en-US%22%3ECAR%20RACING%20USING%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2381077%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20there%2C%20I%20hope%20someone%20can%20help%20me%20out!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20do%20a%20car%20racing%20using%20excel.%20The%20car%20need%20to%20follow%20the%20track%20(%20attached%20below).%20The%20vehicle%20need%20to%20change%20the%20gear%20as%20shown%20in%20the%20picture.%20The%20problem%20is%2C%20Im%20not%20sure%20how%20to%20make%20the%20vehicle%20follow%20the%20track.%20Should%20I%20draw%20the%20track%20on%20the%20excel%2C%20then%20assigned%20color%20of%20the%20line%20based%20on%20the%20gear%2Fspeed%20of%20the%20vehicle%20I%20code%20in%20the%20excel%3F%20is%20it%20possible%3F%20or%20anyone%20have%20a%20better%20idea.%20This%20is%20my%20first%20time%20using%20VBA!%20I%20have%20done%20the%20calculation%20part%20and%20Im%20stuck%20here%20-%2C-%26nbsp%3B%3C%2FP%3E%3CP%3ETHANKS%20IN%20ADVANCE!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sepang-track-map-telemetry.jpg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F283131iE084B5CC0648074A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Sepang-track-map-telemetry.jpg%22%20alt%3D%22Sepang-track-map-telemetry.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2381077%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2381133%22%20slang%3D%22en-US%22%3ERe%3A%20CAR%20RACING%20USING%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2381133%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1061804%22%20target%3D%22_blank%22%3E%40salsblaalyfi%3C%2FA%3E%26nbsp%3BWho%20or%20what%20made%20you%20think%20that%20this%20is%20something%20you%20would%20do%20in%20Excel%3F%20Drawing%20a%20track%20and%20show%20a%20moving%20car%20on%20it%2C%20that%20is.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2382621%22%20slang%3D%22en-US%22%3ERe%3A%20CAR%20RACING%20USING%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2382621%22%20slang%3D%22en-US%22%3Emy%20lecturer%20ofc!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20problem%20is%2C%20I%20couldn't%20identify%20which%20command%20should%20be%20used%20to%20make%20the%20car%20follow%20the%20track.%3C%2FLINGO-BODY%3E
Frequent Visitor

Hello there, I hope someone can help me out!

 

I need to do a car racing using excel. The car need to follow the track ( attached below). The vehicle need to change the gear as shown in the picture. The problem is, Im not sure how to make the vehicle follow the track. Should I draw the track on the excel, then assigned color of the line based on the gear/speed of the vehicle I code in the excel? is it possible? or anyone have a better idea. This is my first time using VBA! I have done the calculation part and Im stuck here -,- 

THANKS IN ADVANCE!

 

 

 

Sepang-track-map-telemetry.jpg

1 Reply

@salsblaalyfi Who or what made you think that this is something you would do in Excel? Drawing a track and show a moving car on it, that is.