Can anyone make a suggestion on how to display a message box w/o concatenating strings of text, example:
Dim i As Integer
Dim strYachtTypes As String
For i = 0 To frmCharters.cboYachtType.ListCount - 1
strYachtTypes = frmCharters.cboYachtType.List(i)
MsgBox strYachtTypes, , "Show Yacht Types"
Say there were varying elements in the combo box,(user addition/deletion , which is apparent with cboYachtType.ListCount - 1). Obviously this code will print a msgbox the same number of times as the count of the combo box. What I want to do is display the message box 1 time with a list (will never be more than 20) of all items currently in cboYachtType.