Push a button or push a key

[Sahak]

Hi All,

Is it possible entering information from a user into a worksheet either pushing button on the form control or key input (user form is active). For example if user needs to enter employee cod (let say 8) he can push button “8” on user form or push key 8. If yes what is the macro cod?
Thank you in advance

 

[bensonsearch]

do you mean the keydown event? so if he pushes 8 on the userform something happens?

 

[Sahak]

thank you for reply

If I click with mouse pointer on userform’s button CommandButton8 it should enter 8 on cell A1
If on keyboard I push the key 8 it should enter 8 on cell A1.
Either of them should work

 

[bensonsearch]

ok then yes, use the form keydown event and would go something like

if keycode = 56 or keycode = 104 then
thisworkbook.sheets("Sheet1").range("a1").value = "8"
else
end if

the keycode 56 is the normal number 8 key and 104 is the num pad.

to find the codes enter under keydown event
msgbox (keycode)

 

[Sahak]

Hi bensonsearch,

Thank you very much.