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" <(E-Mail Removed)> wrote in message
news:16635B79-5F9B-46A9-8571-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:16635B79-5F9B-46A9-8571-(E-Mail Removed)...
> > 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
>
>
> .
>