Excel VBA macro to move shape right and left with a smooth motion when holding down keys

Ditutup Disiarkan 2 tahun lepas Dibayar semasa penghantaran
Ditutup Dibayar semasa penghantaran

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 Excel VBA Excel Macros

ID Projek: #31531169

Tentang projek

13 cadangan Projek jarak jauh Aktif 2 tahun lepas

13 pekerja bebas membida secara purata €119 untuk pekerjaan ini

merinsinha

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 pl Lagi

€150 EUR dalam 2 hari
(105 Ulasan)
5.3
denalekskhua

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.

€140 EUR dalam 7 hari
(0 Ulasan)
0.0
achalbais077

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.....

€140 EUR dalam 7 hari
(0 Ulasan)
0.0
Asso8899

I have good experience in. M. S world applications like excel etc.. And complate ur work in more accurately. Plz u need to just trust me.

€56 EUR dalam sehari
(0 Ulasan)
0.0