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