Listbox Help

  • Thread starter Thread starter lehainam
  • Start date Start date
L

lehainam

Dear all,

I have created a listbox in Excel but I don't know how to make it
invisible when user presses Esc key as belows:

Private Sub Lst1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)

End Sub

Could any one help me to create VBA code that when user presses Esc key
this listbox become invisible.

Thanks a lot!

Nam
 
Nam,

I came up with this, but it keeps crashing Excel for me. Try it anyway and
see if you get the same

Private Sub ListBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
Select Case KeyAscii
Case 27: ListBox1.Visible = False
End Select
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Listbox Help 1
Keydown event on a userform 2
referring to texbox 4
VBA: Problem with ctrl- and a-key Listbox event 4
Using numeric pad - key in vba 4
Reference Label from TextBox 7
Referring to Group name 1
How to set focus on an ActiveX ListBox 7

Back
Top