Debra's site showed how to name a range.

What kind of trouble did you have with that?

And the combobox will be visible all the time unless you do something special in
code to hide it and show it.

Morfeo wrote:

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


--

Dave Peterson