Hi,
I have a sheet named "Main" and multiselect listbox in this sheet.
I've named the multiselect listbox "Test", in the window just above the column A, next to the formula/cell value input field
However when trying to run a macro which is to return the selections in the multiselect listbox. I get an error i the VBA code that "object required".
Sub Knapp9_Klikk()
' Submit knappen
Dim lItem As Long
For lItem = 0 To Test.ListCount - 1
If Test.Selected(lItem) = True Then
Main.Range("A65536").End(xlUp)(2, 1) = Test.List(lItem)
Test.Selected(lItem) = False
End If
Next
End Sub
What I want the macro to do is bascially. Output for each option in the listbox either TRUE or FALSE. Where the first should be outputted in cell A1, then B1, C1, etc..
I will then use the input created in these cell, for a later procedure..
Hope someone can shed some light on this...
PS!! I'm using Excel 2007 and Vista
Bookmarks