Windows key and keycode
leerem wrote:
I have a workbook that uses multiple userforms that users on the warehouse
floor enter information onto.
The problem I have is that users are crashing the workbook.
I've managed to disable the Break key as well as the Ctl-Alt-Delte combination
However the Windows key is a bit more of a challenge, I thought I could
capture the keystroke as follows:
Sub UserForm_KeyDown(ByVal keycode As MSForms.ReturnInteger, ByVal _
Shift As Integer)
'Capure the KeyStroke
If keycode = 92 Or keycode = 91 Then
' Throw away the Key Stroke
keycode = 0
MsgBox "Your Shouldn't be pressing the Windows Key!"
End If
End sub
But this doesn't stop the Start Window from showing.
ITYM ByRef keycode since you are trying to alter the value returned.
I don't see why having the start window showing crashes your application.
Regards,
Martin Brown
|