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

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

If you are doing from a worksheet (as distinct from a user form) you can use
Excel's built-in Validation function (under Data Validation on the Data
menu). You use "List" in the "Allow" box and you name the Range in the
"Source" box, preceded by the "=" sign.


--
Time is just the thing that keeps everything from happening all at once


"Jodie" wrote:

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

Thank you Neptune. I was actually wanting to write this in code. I do have
my answer now though. Again, thanks for your help.
--
Thank you, Jodie


"Neptune Dinosaur" wrote:

If you are doing from a worksheet (as distinct from a user form) you can use
Excel's built-in Validation function (under Data Validation on the Data
menu). You use "List" in the "Allow" box and you name the Range in the
"Source" box, preceded by the "=" sign.


--
Time is just the thing that keeps everything from happening all at once


"Jodie" wrote:

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

Thanks, this looks useful.

--
Thank you, Jodie


"JLGWhiz" wrote:

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


.