Đã Đóng

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

Kĩ năng: Excel, Excel VBA, Excel Macros

Xem nhiều hơn: 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

Về Bên Thuê:
( 21 nhận xét ) Täby, Sweden

ID dự án: #31531169

13 freelancer chào giá trung bình€119 cho công việc này

(824 Nhận xét)
8.9
(421 Nhận xét)
8.3
P0L

(476 Nhận xét)
8.0
(174 Nhận xét)
7.0
(72 Nhận xét)
6.1
(16 Nhận xét)
5.8
(29 Nhận xét)
5.2
(18 Nhận xét)
5.2
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 Thêm

€150 EUR trong 2 ngày
(105 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
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 trong 1 ngày
(0 Nhận xét)
0.0
farhansaad69

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 Thêm

€80 EUR trong 3 ngày
(0 Nhận xét)
0.0