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.

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

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

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

Thank You 8-)

ok, i know how to name a range, and then i know that i can use that name for
the data validation, i use it for the drop down list.

i highlight the cells that i want for the dropdown list, data, validation,
list, i put the source, enter.

and the dropdown list appears and works.

and then i activate the control toolbox, click on the combo box icon, i make
the combo box, in an empty space of the worksheet,select it, click
properties, customize it, name, font, list row, match entry, it would be
1-fmmatchentrycomplete, and everything.

and then insert the code in VBA to make it work, close it, and then click
on the cells with the dropdown list, type just one letter, and nothing
happens, y keep typing and the match entry does not work.

i put the source in the same worksheet, and it works! for right now, i have
it that way, in every single sheet, that is why i am making this S.O.S.

if you want i can send you a copy of my workbook, if you want to analyze it.

do you know if there's a way to avoid the double click and use the keyboard?
it is kind of annoying stop typing to use the double click.

thank you, and let me apoligize again, and i cannot believe the fast that
you answer, thank u again.

"Dave Peterson" wrote:

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

What name did you use? How did you create that name?

How did you assign the rowsource to that combobox?
What did you type into the listfillrange property (if you did it manually).

Maybe you're doing something wrong with your code? Hard to guess with no
details.

And keep the discussion in the newsgroups. You'll have more people reading your
message and maybe more people helping.



Morfeo wrote:

Thank You 8-)

ok, i know how to name a range, and then i know that i can use that name for
the data validation, i use it for the drop down list.

i highlight the cells that i want for the dropdown list, data, validation,
list, i put the source, enter.

and the dropdown list appears and works.

and then i activate the control toolbox, click on the combo box icon, i make
the combo box, in an empty space of the worksheet,select it, click
properties, customize it, name, font, list row, match entry, it would be
1-fmmatchentrycomplete, and everything.

and then insert the code in VBA to make it work, close it, and then click
on the cells with the dropdown list, type just one letter, and nothing
happens, y keep typing and the match entry does not work.

i put the source in the same worksheet, and it works! for right now, i have
it that way, in every single sheet, that is why i am making this S.O.S.

if you want i can send you a copy of my workbook, if you want to analyze it.

do you know if there's a way to avoid the double click and use the keyboard?
it is kind of annoying stop typing to use the double click.

thank you, and let me apoligize again, and i cannot believe the fast that
you answer, thank u again.

"Dave Peterson" wrote:

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


--

Dave Peterson