I am pretty sure I have had this work before, but right now it's not working for me, but my computer is acting all pi**y right now anyways so it may be me.
anyways...the select box should be basically a comma delimited variable. So, you can use the split command and that will give you an array.
dim tmpArray
dim i
tmpArray = split(msgbox, ", "
for i = lbound(tmpArray) to ubound(tmpArray)
' do whatever
next
Something quite similar to that should work I believe. I appologize in advance if I am wrong and that does not work.
For i = 0 to (mulSel.Options.Length-1)
if mulSel.Options(i).selected Then itms = itms & _
mulSel.Options(i).value & " - " & _
mulSel.Options(i).Text & vbcrlf
Next
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.