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

[Alvin Wilson]

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
--
Regards,
Tom Ogilvy


"Alvin Wilson" <alvinwilson@(NoSpam)peacemail.com> wrote in message
news:3EAB5A24-48C5-4355-9BFD-E0F6186CB4F7@microsoft.com...
> 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!