software

I added a drop down control to my sheet1 from the forms menu.
I want the data which will show up in this control to be from a range name
of quot;Productsquot; from the quot;Dataquot; sheet. If I place quot;Data!Productsquot; into the
quot;Input Rangequot; on the Control Tab of the Format Control dialog box, the system
changes this to my file name!Products.
Do I not have the proper format for specifying the range?

Can I reference this control in my VBA Code...I see no name that I can use
for the object name....

You do not need to specify the sheet when dealing with named ranges, if
quot;productsquot; is the name of the range then type:
=products

HTH
JG

quot;Jim Heaveyquot; wrote:

gt; I added a drop down control to my sheet1 from the forms menu.
gt; I want the data which will show up in this control to be from a range name
gt; of quot;Productsquot; from the quot;Dataquot; sheet. If I place quot;Data!Productsquot; into the
gt; quot;Input Rangequot; on the Control Tab of the Format Control dialog box, the system
gt; changes this to my file name!Products.
gt; Do I not have the proper format for specifying the range?
gt;
gt; Can I reference this control in my VBA Code...I see no name that I can use
gt; for the object name....