Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
floating toolbar | Excel Programming | |||
Floating Toolbar | Excel Discussion (Misc queries) | |||
PDF 4.0 Floating Toolbar | Excel Discussion (Misc queries) | |||
floating toolbar | Excel Programming | |||
Floating Toolbar | Excel Programming |