Forum Discussion

adlih's avatar
adlih
Copper Contributor
Jul 24, 2020

[ HELP ] VBA In a user form, a problem occur after I used [ SendKeys "{ }"]

VBA In a user form,  I used [ SendKeys "{ }"], Then NumLock  AUTO DROP sometime =   =  HOW TO prevent THAT?     
excel
Subodh_Tiwari_sktneer's avatar
Subodh_Tiwari_sktneer
Silver Contributor
Jul 24, 2020

adlih 

Refer to the following screenshot to know how to rename a Class Module.

adlih's avatar
adlih
Copper Contributor
Jul 27, 2020

Thank you for your message,
but the problem still occur Subodh_Tiwari_sktneer 

 

MY MAIN CODE HERE:

Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = 13 Then
CommandButton1_Click
SendKeys "{LEFT}"
Dim numLock As New NumLockClass
If numLock.value = False Then numLock.value = True
End If
End Sub

  • Subodh_Tiwari_sktneer's avatar
    Subodh_Tiwari_sktneer
    Silver Contributor
    Jul 27, 2020

    adlih 

    You are right. After testing it multiple times I also found that the numlock gets turned off after regular intervals. SendKeys are notorious for this weird behavior. 

    I will let you know if I come across any workaround for this.

Resources