Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Good Evening Group,
Below code works fine when my ListBox is in normal mode. But how to rewrite the code to work in MultiSelectMulti mode? Hope for your skilled assistance. Brgds CG Rosén Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) With Blad1.Range("A1:A100") Set k = .Find(UserForm1.ListBox1.Text, _ LookIn:=xlValues, _ LookAt:=xlWhole, _ SearchOrder:=xlByColumns) If Not k Is Nothing Then r = k.Row Sheet1.Cells(r, 1).ClearContents End If End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MODE calc where more than one mode number! | New Users to Excel | |||
VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) | Excel Programming | |||
Combo Box goes to edit mode even if design mode is in OFF position | Excel Discussion (Misc queries) | |||
coverting answer from Radian mode to degree mode | Excel Worksheet Functions | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming |