Hello, Thank you for your answer =D

This Website has a lot of useful information, but i have a little problem, i
ask this t you because i think debra is not going to anwser my questions, but
anyways.

i folloew step by step everything what she says,but i seem to miss something
that i do not know what it is.

look, i name the range that i want it to appear on the data validation
cells, then, i insert the control toolbox bar, insert the combo box,
properties window, change name, change font, the listrows, the matchentry, i
put -1frommatchentrycomplete,
close the window, exit design mode, click on the cells that have the
validation data, but the combo box does not dissapear, do you know what did i
do wrong?

and before that, i realized that i have to put the information that i want
on the data validation in the same sheet, because it does not work. but first
i need help with the name range.

let me apologize for my ignorance.
"Dave Peterson" wrote:

Yep.

Debra Dalgleish explains how to use a range from a different worksheet in the
same workbook:
http://contextures.com/xlDataVal01.html#Name

And in the combobox's rowsource property field, you can type that same workbook
level name.

Morfeo wrote:

Hello, How's it going?

Look, i created a data validation in a excel sheet with a customer list, i
have the cells with the validation, i have created a "combo box", i named it,
i made all the changes necessaries, i close the properties window, exit the
design mode, put the VBA code, and the double clik on the validation cell,
and it works, but i had to put all the customer list in the same sheet.

can it is possible that i can name the values that i want to use for the
validation and then use them for the combo Box?

Thx.

--

Dave Peterson