List box: Populate with Range Names
 

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

List box: Populate with Range Names
 

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

--
HTH

Bob Phillips

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

List box: Populate with Range Names
 

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