Combo Box multi select into 1 cell
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 ??????
Last edited by The_Vulcan; 01-19-2007 at 01:00 AM.
BUMP me
HI
Don't know that you can multiselect in a combobox, but you can in a listbox.
rylo
Oops sorry it is a ListBox.
If I have it set to single it will allow me to select 1 entry and enter it and highlight the entry when I reopen the form.
But when I change it to MultiSelect it gives error
Runtime error 380
Could not set the value property. Invalid property value.
Hi
The listbox is called mylistbox and there is a command button called commandbutton1.
See how this code goes.
I know there is a problem if the button is pushed but no selections have been made, but that can be sorted out later.
Please Login or Register to view this content.
rylo
THANKYOU THANKYOU THANKYOU
I couldn't have written that if my life depended on it and I have been Googling for hours with no luck.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks