L
lehainam
Dear all,
I have a listbox in Excel, I created a code that when user press Esc
Key the list box become invisible:
Private Sub LstCreditor_KeyPress(ByVal KeyAscii As
MSForms.ReturnInteger)
Select Case KeyAscii
Case 27
LstCreditor.Visible = False
End Select
End Sub
But when user presses Esc Key the Excel file trigger a bug and then
automatically exit from Excel.
Could any help me!
Thanks in advance
Nam
I have a listbox in Excel, I created a code that when user press Esc
Key the list box become invisible:
Private Sub LstCreditor_KeyPress(ByVal KeyAscii As
MSForms.ReturnInteger)
Select Case KeyAscii
Case 27
LstCreditor.Visible = False
End Select
End Sub
But when user presses Esc Key the Excel file trigger a bug and then
automatically exit from Excel.
Could any help me!
Thanks in advance
Nam