Hello everybody, this is a tutorial in which a virtual Excel joystick controlled by mouse movements on a scatter chart has been demonstrated . While in operation, a macro updates the coordinates of the pointer in two spreadsheet cells. The two coordinates are then incorporated in formulas which limit the range of motion of the joystick. Just like a real device the stick head movement is confined within a square (with a side length of 200 pixels) and so is the numerical output (limited to [-100,100] on both X and Y). Immediate applications of this joystick are: a race car game (acceleration, brake and steering), a flight simulator (emulates an airplane cockpit yoke or control stick – Roll+Pitch), a shooting game (azimuth and altitude cannon control), or a combination of the above applications. Good luck, George
Usage: If the macro is stopped, click the chart to start it. It is a good idea to position the pointer in the origin of the chart before clicking, this way the cursor will roughly be positioned on top of the joystick head on the chart. The joystick position is controlled by the mouse movement. To stop the macro click the chart again.