PDA

View Full Version : Keyboard



Tvercetti
11-29-2007, 04:17 PM
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
11-29-2007, 05:01 PM
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
11-29-2007, 05:26 PM
Never tried it, but if you want to treat your users like children, this (http://babymouse-and-babyboard.dolesoft.qarchive.org/_download2.html) seems entirely appropriate.

Tvercetti
11-29-2007, 05:31 PM
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
11-29-2007, 05:43 PM
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
11-29-2007, 05:57 PM
For Excel games, have you tried Bartek's website (http://www.dzikosoft.com/). You might get assistance there