This will give you an idea:

http://www.ehow.com/how_2056378_crea...ual-basic.html


"Jodie" wrote in message
...
Is is possible to write a macro to create a list box that uses information
from a named range? The user would only be able to select one item from
the
range.
--
Thank you, Jodie