Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
drop-down / combobox in a custom toolbar
Hi All,
I have created a combobox on a worksheet which, upon activation of the sheet, gets populated with the names of all the 'named ranges' in the workbook. selecting one of these takes you to the named range chosen. it all works fine, but now i want to have it (or something similar) in a toolbar... can anyone tell me how to do it? i don't know how to get something like a combobox into a toolbar (eg, like the font selection drop-down). part of the reason for doing the above is that i create quite a few dynamic ranges (via VBA) and they never appear on the 'go to' window ('Edit' - 'Go To...'). can anyone tell me why they don't appear when other named ranges do and is there anyway of forcing them on to that list (using VBA)? Thanks for any help, Tim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating combobox in custom toolbar | Excel Programming | |||
VBA - Disappearing custom menu and custom toolbar | Excel Programming | |||
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! | Excel Programming | |||
How to make the drop down for comboBox visible in toolbar | Excel Programming | |||
saving toolbar buttons on custom toolbar | Excel Programming |