user form-on open event? keydown event?

F

FSt1

Does a user form have an on open event and a keydown
event. if so how do i set them. i have the code. i just
don't know how to trigger it.
 
H

Harald Staff

Hi

Yes. Rightclick it in the VB editor, choose View Code, to get to its module.
There, choose "Userform" in the top left dropdown and KeyDown in the top
right to generate the event code. "Initialize" runs on load and "Activate"
on every show.

However, a userform Keydown won't run if you type into a control like a
textbox. You need that control's KeyDown event for that, there is no
keypreview property to help.

HTH. Best wishes Harald
 
F

Fst1

thanks Harald
-----Original Message-----
Hi

Yes. Rightclick it in the VB editor, choose View Code, to get to its module.
There, choose "Userform" in the top left dropdown and KeyDown in the top
right to generate the event code. "Initialize" runs on load and "Activate"
on every show.

However, a userform Keydown won't run if you type into a control like a
textbox. You need that control's KeyDown event for that, there is no
keypreview property to help.

HTH. Best wishes Harald

"FSt1" <[email protected]> skrev i melding


.
Click to expand...
 
Top