Sorry Title Should have been "ListBox MultiSelect"
I have a form with a List box.
Private Sub UserForm_Initialize()
With MyListBox
.AddItem "Alpha"
.AddItem "Bravo"
.AddItem "Charlie"
.AddItem "Delta"
End With
End Sub
I need to be able to multi select and place the values into 1 cell.
A1 = Alpha, Charlie , Delta
When the form is re-opened I need the List box to highlight Alpha, Charlie , Delta
MyCListBox.Value = ActiveCell.Value
Any Help Please ??????
Bookmarks