Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA: Problem with ctrl- and a-key Listbox event
Hi,
I try to let VBA copy a listbox items when holding down the ctrl- and pressing the a-key (select all). Any suggestion on why this doesn't work? Do I need to combine a KeyPressed event? Thanks in advance Regards Frank ___________________________ Private Sub Listbox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer) Dim i As Integer If KeyCode = 97 And Shift = 2 Then For i = 0 To Listbox1.ListCount - 1 Listbox2.AddItem Listbox1.List(i) Next i End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ListBox Click Event | Excel Discussion (Misc queries) | |||
listbox click event help | Excel Programming | |||
Click event on listbox | Excel Programming | |||
Trap CTRL+C keypress event | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming |