List box: Populate with Range Names

[CinqueTerra]

UserForm1 contains a List Box that I would like to populate with the range
names contained in the active Workbook. Thanks in advance!

[Bob Phillips]

With Listbox1
For Each nme In Activeworkbook.Names
.AddItem nme.Name
Next nme
End With

--
HTH

Bob Phillips

"CinqueTerra" <[email protected]> wrote in message
news:[email protected]...
> UserForm1 contains a List Box that I would like to populate with the range
> names contained in the active Workbook. Thanks in advance!

[Dave Peterson]

Are you building a utility to help you keep track of names in a workbook.

If you are, you may want to see 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


CinqueTerra wrote:
>
> UserForm1 contains a List Box that I would like to populate with the range
> names contained in the active Workbook. Thanks in advance!

--

Dave Peterson