handle ctrl+enter

[BlackMustard]

hello,

i have a userform in a vba macro which contains three text boxes. sometimes i want to fill in only the first one, and other times one or two of the other as well. when i today want to leave a box empty, i have to press [tab] one or several times to reach the "submit" command button.

is there a way that i could trigger the btnSubmit_Click() event by pressing [Ctrl]+[Enter]? how?

[sachinkale123]

... is there a way that i could trigger the btnSubmit_Click() event by pressing [Ctrl]+[Enter]? how?

Hi,

Check the below code, I think that will answer your question

Private Sub  btnSubmit_Click() 
MsgBox "Submitted"
End Sub
 
Private Sub Text1_KeyPress(KeyAscii As Integer)
If KeyAscii = 10 Then
  btnSubmit_Click
End If
End Sub

Reply me...

[hariharanmca]

... is there a way that i could trigger the btnSubmit_Click() event by pressing [Ctrl]+[Enter]? how?

I think the below link will help you

KeyAscii

[BlackMustard]

Hi,

Check the below code, I think that will answer your question

Private Sub  btnSubmit_Click() 
MsgBox "Submitted"
End Sub
 
Private Sub Text1_KeyPress(KeyAscii As Integer)
If KeyAscii = 10 Then
  btnSubmit_Click
End If
End Sub

Reply me...

thank you! this worked excellently!

[BlackMustard]

Hi,

Check the below code, I think that will answer your question

Private Sub  btnSubmit_Click() 
MsgBox "Submitted"
End Sub
 
Private Sub Text1_KeyPress(KeyAscii As Integer)
If KeyAscii = 10 Then
  btnSubmit_Click
End If
End Sub

Reply me...

this worked, but now i'm building an application with a lot of controls in several forms. is there a way i could get the same results as if i coded a similar procedure for each control, but by just having one sub? that is, a sub that handles keypress events regardless of which control sends the event.