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

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

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

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