KeyCodes for using Shift+Ctrl

[Mamud]

Hi,

How could i use the keys shortcut im my userforms

i have a userform contains some command-buttons like (Add, Amend, save, Exit, Next, Previous and delete)

i have these codes for "Add" button and "Exit"

Please Login or Register  to view this content.

Please Login or Register  to view this content.

i need a code allow me to use these shortcuts:
Ctrl + S
or Shift + ctrl
or Alt + T

[pike]

Hi Mamud

I usally modify this bit of old code

Please Login or Register  to view this content.

[Mamud]

Hi pike,

In any event should i add that code ?? and what's function

[pike]

keys shortcut im my userforms the code is in the user form
can you attach the form?

[Mamud]

Hi pike,

In any event should i add that code ?? and what's function ??

[pike]

Hi Mamud
it allow short cut keys for userforms
not knowing the userform i dont know how you need to apply and modify the code

[Mamud]

Hi pike,

sorry for duplication!

I meant how can i specify the keys in that code ?

[romperstomper]

If you are holding down Ctrl then the Shift variable supplied by the event will be 2; if holding down Shift key then it will be 1.
So for Ctrl+C test if Shift = 2 and Keycode = 67 for example.

[pike]

Hi Mamud
I was thinking

but after reading rompers post

this can be adapted futhur

Please Login or Register  to view this content.

[pike]

or

Please Login or Register  to view this content.

[Mamud]

hi pike, hi rompers

the two updated codes dont work with me, pike
but when i changed the shift from 2 to 1 in the second code, it works (Ctrl+F)

Now, i need to know how can i use that code for (Ctrl+Shift)
and what should i do to use (Alt) key (shift = ???)

thx again

[romperstomper]

Ctrl = 1
Shift = 2
Alt = 4

add them up for combinations of the three.

[pike]

Maybe you can use the keyup

Please Login or Register  to view this content.

[Mamud]

sorry pike, sorry rompers

what is the code for using the function keys ??

and I want the tables for the keycode numbers for all keys, if u have a link

thx again

[romperstomper]

Look up KeyCodeConstants in the Object Browser.

[Mamud]

sorry again

i cant write this code anymore

really i need a help

Please Login or Register  to view this content.

nothing works...

[romperstomper]

What is Keyhandler?

[Mamud]

sorry again

i cant write this code anymore

really i need a help

Please Login or Register  to view this content.

nothing works...

[pike]

Hi
Since i didnt have your workbook I used KeyHandler which is the name of a listbox you used Form?

[Mamud]

What is Keyhandler?

I used that event from pike's posts !!!

[Mamud]

please if anyone can correct that code

Please Login or Register  to view this content.

[pike]

you will need to change keyhandler to form

[romperstomper]

I suspect you wanted Userform rather than KeyHandler.
Also, you can't check if Shift is 1 and Shift is 2, you just check if Shift is 3.

[Mamud]

did every keycode in the code is right or not

i talk about (F1, Alt+D, Home, End, Delete, Page up and down)

[pike]

Button KeyCode
Left Button 1
Right Button 2
Cancel 3
Mbutton 4
Back 8
Tab 9
Clear 12
Return 13
Shift 16
Control 17
Menu 18
Pause 19
Capital 20
Escape 27
Space 32
PageUp 33
PageDown 34
End 35
Home 36
Left 37
Up 38
Right 39
Down 40
Select 41
Print 42
Execute 43
Snapshot 44
Insert 45
Delete 46
Help 47
Numlock 144
ScrollLock 145