I'm trying to code a platform game in Excel where the user can move a figure right and left while holding down the keys, like in Super Mario Bros and other classics. I manage to get a simple shape to move back and forth but the animation doesn't run smooth enough. The movement of the shape is uneven. Depending of what technique I try, the shape either start moving once I press the key down but then pauses for a short while and then resuming (just like any typing on the keyboard does when holding a key down), or the shape is "stuttering" during movement in the running loop when I hold the key down.
I have experimented with different techniques to catch the key event (worksheet_onchange, windows system lib) and one issue to handle is the long press of the keys. I want the shape to start moving the instant I press down right or left and it should continue to move while holding the key down.
Preferably I want to use left and right arrow for movement but this is not crucial.
Do deliver if you can solve this, is a simple excel workbook with:
* Standard vba code - references to windows libs like "kernel32" are ok, but not any custom coded activex components or similar
* A sheet with a simple Excel shape as figure
* A macro with a loop that can be started and when running, moves the shape to left and right when pressing and holding down (important!) arrow keys (or others) in a smooth action
And it should work in current version of Office 365 (I have 2002 build 12527.20442).
13 freelancere byder i gennemsnit €119 timen for dette job
Dear Hiring Manager, Greetings from Denys ,hope your day is going well and all is good with you. We would like to discuss the project in details before confirming the bid, so kindly let me know when you are available.
I'm a collage student i need a job because my fanancial condition is very low... I doesn't have a any type of job experience but i give my best.....