Excel VBA macro to move shape right and left with a smooth motion when holding down keys
€30-250 EUR
Fermé
Publié il y a plus de 3 ans
€30-250 EUR
Payé lors de la livraison
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).
Excel VBA Expert.
As 9+ years experiences in these field. I can give good quality work.
I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom give me a chance to show you the best i can do at your service.
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.