If you have hundreds of CCs and you wish to ListBox them, where is the list
stored?

--

Regards,
Nigel




"Danny" wrote in message
...
I would like to find out if it is possible in Excel 2003 to build a
list box that does the following

If a field Cell A1 is populated with cc=23456 or cc=12345 or cc=45678
(CC is Cost Center)
Is it possible to get this into a list box using vba in this format

cc=23456
cc=12345
cc=45678

If so how?

The second issue is the field Cell A1 that the list box pulls from can
be populated with different numbers of costcenters and values
example
cc=23456 or cc=12345 or cc=45678 or cc67890 Which is 4 different cc's
the above example only has 3. There could be 100 cc's

The logic is always the same format cc=5 digits or cc=5digits and has
or seperating them etc...

Is it possible to use VBA to list into a listbox the above scenarios?

If you need more information please let me know.

Thanks