How to reference the contents of a list in a floating toolbar?

[Guest]

I've created a floating toolbar with a dropdown list on it. When the user
clicks a selection on the dropdown list, a procedure is called. Within that
procedure, I can see the value of ListIndex for the list, but I can't figure
out how to reference the value or text or contents at the location pointed to
by ListIndex. I know how to do this in Access, but Excel seems to require a
different approach.

How do I reference the contents of a list in a floating toolbar, given that
I know the ListIndex of the selection?

TIA!

 

[Tom Ogilvy]

with Commandbars("custom1").controls("Drop1")
s = .List(.ListIndex)
End With
msgbox s