MultiSelect & order of choose
You could possibly handle it with code similar to this. However, you should
realize that the user could remove a selection after previously selecting it
and therefore that needs to be handled as per the comment.
Private Sub ListBox1_Change()
If ListBox1.Selected(ListBox1.ListIndex) Then
MsgBox "Value selected = " & _
ListBox1.List(ListBox1.ListIndex)
'Code here in lieu of msgbox to save the value _
to a list on worksheet
Else
MsgBox "Value cleared = " & _
ListBox1.List(ListBox1.ListIndex)
'Code here in lieu of msgbox to remove value _
from saved list on worksheet
End If
End Sub
--
Regards,
OssieMac
"Adax" wrote:
Hello! Excel 2003, form and ListBox (MultiSelect and frmListStyleOption).
User choose some positions from the ListBox and I must to know how was order
of this choose? I want this information to order results in the sheet. For
example: I can choose position 2,3,4 of the listbox, but ones in order: 234,
next 432, 342... Is it possible get this information of choose order in
VBA? Help me please! Greetings!
|