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

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

Kemahiran: Excel, Excel VBA, Excel Macros

Lihat lagi: excel vba macro paste adjacent column, paste excel vba macro, excel vba macro databases, excel vba macro programming bids, excel vba macro calculate business days, excel vba macro find text morld, generate report excel vba macro, excel vba macro optimization, excel vba macro protect cell, excel vba macro charts, running excel vba macro sql server, excel vba macro scripter, download historical stock data excel vba macro, excel vba macro copy columns data, convert excel vba macro standalone application, excel vba macro download yahoo stock data, excel vba macro worksheet name, select column copy excel vba macro, excel vba macro freelance, excel vba macro lotto numbers

Tentang Majikan:
( 21 ulasan ) Täby, Sweden

ID Projek: #31531169

13 pekerja bebas membida secara purata €119 untuk pekerjaan ini

(824 Ulasan)
(421 Ulasan)

(476 Ulasan)
(174 Ulasan)
(72 Ulasan)
(16 Ulasan)
(29 Ulasan)
(18 Ulasan)

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)

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)

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)

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)

Hi there, I am Highly interested in your project. I am highly skilled in adobe after effects and 2D/3D animation, logo design & video editing. I am bidding low because I am new to this site I can assure you that if yo Lagi

€80 EUR dalam 3 hari
(0 Ulasan)