Adding list box

  • Thread starter Thread starter Jodie
  • Start date Start date
J

Jodie

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.
 
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.
 
Thank you Neptune. I was actually wanting to write this in code. I do have
my answer now though. Again, thanks for your help.
 
Back
Top