it's the second step that i cannot do. i could define the list but it's the
validation that gives me troubles.
how do i have to do? so far i did from the main menu but i guess it's not
there...
thanx


I see. . .
Then what you have to do is:
From the Main Toolbar select Insert-Name-Define
Once you have the dialog box, Type any name on it like mylist or something
and then
on the refers to box click on the icon with the red arrow and go to the
sheet where your range is and highlight the range or simply type the
reference like so:

=Sheet2!$H$3:$H$8
Hit Ok
Now, when you do your data validation, on the settings tab select from the
Allow dropdown: List
and on the source type =mylist
Or whatever you name you range on the first step. That should do the trick.
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.





"Michael" wrote:

Change the type of dropdown. Must likely you selected your
dropdown from the Forms Toolbar, You must now create your dropdown using the
Control Toolbox Toolbar(click on the View Option from your Main Menu to
select).
Once You insert your combobox(dropdown), right click on it and select
properties,
Click on the "Categorized" tab and under the Miscellaneous Category place
your data range cell reference on the ListFillRange (i.e. Sheet1!A1:A50)
This allows to use a different worksheet than the one currently in use.


--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"massi" wrote:

I am trying to create a drop down list.
i have a spreadsheet with the list of the values i want in the drop down
menu in an other workbook
i have followed the instruction of:
http://office.microsoft.com/en-us/ex...022151033.aspx
but when i try to insert the drop down list i get an error msg.
in the final work book i went to Data/Validation, i have select List from
allow window but when i try to define the actual list i need from an another
workbook the message that appears is:
"you may not use references to other worksheets or workbooks for Data
Validation criteria"
what do i do wrong?
thanks in advance