user form-on open event? keydown event?

[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.

 

[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

 

[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


.