Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi a have list box with this code in it.
Private Sub ListBox1_Click() ActiveCell.Value = ListBox1.Value strStartDir = ThisWorkbook.Path GraphicFile = strStartDir & "\150\" & ActiveCell.Value & "a.jpg" Image1.Picture = LoadPicture(GraphicFile) ActiveCell.Value = ListBox1.Value strStartDir = ThisWorkbook.Path GraphicFile = strStartDir & "\150\" & ActiveCell.Value & "b.jpg" Image2.Picture = LoadPicture(GraphicFile) End Sub everything works fine except when in the list box, if two items get clicked on or highlighted at the same time by accident then I get a runtime error 53. How can I force only one item to be selected. I have multiselect set to single from the list box options. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Listbox 2 takes the value of Listbox 1 | Excel Discussion (Misc queries) | |||
listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming |