endurance
asked on
Simple Excel 2010 MultiSelect Listbox retrieval
See attached.
When an item is clicked in the multiselect listbox the code should
first show the # of items in the list (which it does fine)
then show true/false indicating if the 1st item was selected - instead it returns an error "Unable to get the selected propery of the listbox"
Any idea - I'm sure it's something silly I'm overlooking.
Again I'm using Excel 2010
thx
Sub ListBox1_Change()
With Worksheets("Sheet1").ListB oxes("List Box 1")
MsgBox (.ListCount)
MsgBox (.Selected(0))
End With
End Sub
Sample-MultiSelect.xlsx
When an item is clicked in the multiselect listbox the code should
first show the # of items in the list (which it does fine)
then show true/false indicating if the 1st item was selected - instead it returns an error "Unable to get the selected propery of the listbox"
Any idea - I'm sure it's something silly I'm overlooking.
Again I'm using Excel 2010
thx
Sub ListBox1_Change()
With Worksheets("Sheet1").ListB
MsgBox (.ListCount)
MsgBox (.Selected(0))
End With
End Sub
Sample-MultiSelect.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER