| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Double click item in Listbox to select item and close Listbox
Hi Gus
You could do it using code like that listed below Option Explicit Dim LstSelection As String Private Sub CommandButton1_Click() Call DoYourThingHere End Sub Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) Call DoYourThingHere End Sub Sub DoYourThingHere() LstSelection = ListBox1.Value MsgBox LstSelection ListBox1.Visible = False End Sub hope this helps S |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ListBox3.ListIndex = ListBox3.ListCount -- How to select the last item in a Listbox? | Excel Programming | |||
| listbox add item | Excel Programming | |||
| Need selected item from listbox after double click | Excel Programming | |||
| select listbox item automatically | Excel Programming | |||
| Select an item in a listbox using code | Excel Programming | |||
Threaded Mode
