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.