hi,
below is my code which i have for a drop down list within my userform...
i have been asked to select a name from a listbox then use the combo box to select a "mr" "miss" etc to them show up together in a label.
the problem i have is that every time i click on the drop down it duplicates the list that is already there,,
could someone please advise of a way to stop this
thank you
Private Sub comList_DropButtonClick() With comList comList.AddItem "Miss" comList.AddItem "Mrs" comList.AddItem "Mr" comList.AddItem "The Awesome" comList.AddItem "Doctor" comList.AddItem "The Incredible" End With End Sub
Last edited by 10121730; 02-01-2012 at 05:53 PM. Reason: changing to solved
Put that code in the Userform_Initialize event.
It will run once and the list will always have those 6 items in it.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks