Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 173
  • Last Modified:

Calling a module in a form.

How do you get a module to run in a form. Here is the code that I have in a module "If (KeyAscii = 13) Then SendKeys "{TAB}"".  I don't want to type it everytime and want to call it from a procedure.
0
matthewkwp
Asked:
matthewkwp
  • 2
1 Solution
 
mcixCommented:
In the module define a function or sub-routine to do what you want to do...

Like this:

Public Sub WhichKeyWasPressed(KeyAscii As Integer)
    If KeyAscii = 13 Then
        SendKeys"{TAB}"
    End If
End Sub


0
 
mcixCommented:
You could also set KeyPreview to True on the Form and insert the following code:

Private Sub Form_KeyPress(KeyAscii As Integer)
    Select Case KeyAscii
        Case 13
            SendKeys "{Tab}"
            KeyAscii = 0
    End Select
End Sub
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now