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

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!

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

with Commandbars("custom1").controls("Drop1")
s = .List(.ListIndex)
End With
msgbox s
--
Regards,
Tom Ogilvy


"Alvin Wilson" wrote in message
...
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!