KeyDown Event Question

[Guest]

Hello,

I know with VBA Code you can trace what is being entered into a Control with
the KeyDown Event and then with KeyCode...

Private Sub TextBox1_KeyDown(KeyCode As Integer, Shift As Integer)
msgbox KeyCode
End Sub

I also know that in the PROPERTIES of the Control you have On Key Down where
you can assign a Function to there to do something.

What I would like to know is when using the Properties On Key Down, not VBA
code, how can you pass the KeyCode & Shift, know what is being pressed down
so then I can work with it in a Function? Or can this not be done, only with
VBA code ?

Any help would be greatly apprecitaed.

Thank you,
Jeff

 

[Brendan Reynolds]

The latter - you need to use a VBA event procedure in order to access (no
pun intended) built-in event arguments such as KeyCode and Shift.