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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
drop-down / combobox in a custom toolbar
Hi,
Have you tried using the navigator. it's on the formula bar at far left. a little dropdown like a combo box which displays range names and print areas and other. FSt1 "Tim Marsh" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
drop-down / combobox in a custom toolbar
If this is not a learning exercise, then get Jan Karel Pieterse's (with Charles
Williams and Matthew Henson) Name Manager: You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp You'll find that it has a lot of nice features. Tim Marsh wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
drop-down / combobox in a custom toolbar
Thanks FSt1, but it doesn't list my range names... i don't know if its
because they are dynamic or because they were created via VBA (i presume the latter). "FSt1" wrote in message ... Hi, Have you tried using the navigator. it's on the formula bar at far left. a little dropdown like a combo box which displays range names and print areas and other. FSt1 "Tim Marsh" wrote: 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 |
Reply |
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 |