Keyboard

[Tvercetti]

Is there a way to disable using the arrow keys in vba? I want the user to be able to just click on a cell with the left mouse button, but nothing else.
Thx

[mikerickson]

You could use the OnKey to assign them to the following sub.

Sub Null()
End Sub

I'm curious why? Changing the arrows takes away a tool that some users use habitualy. Why make things harder for these users?

[mdmackillop]

Never tried it, but if you want to treat your users like children, this seems entirely appropriate.

[Tvercetti]

I am trying to create a game in excel, and I want to limit the users choice of where to click and what they can do.
I was hoping that they was a function that would allow the user to just click once, but not use the arrow keys or type by mistake.

I do agree that usually this is not the way to go ... but i dont see another option here.

[mikerickson]

The mouse is far from the cursor keys. Its very unlikely that a user would press one by mistake.
If the user wants to play the game, they won't use the cursor keys if you ask them not to in the instructions. Game players don't need to have controls disabled, they want the game to run right.

[mdmackillop]

For Excel games, have you tried Bartek's website. You might get assistance there