Combo Box

[Morfeo]

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]

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]

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]

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]

Thank You

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]

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.

Thank You

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.

 

[Morfeo]

for the name, you mean the name of the combo box or the name for the data
validation?

to create the name of the combo box, properties, at the top, the name field,
type the name, done.

assign the rowsource, i haven't assign nothing in the combo box, except the
rowlist, that shows you how many options you want the combo box shows in the
dropodown list.

Maybe that is the missing point, a rowsource for the combo box, right? i
just customize the font, the name (i told you what i did), the rowlist(), and
the entrymatch, is there something that i have to cuztomize too?

and what is that of the listfill range? i apoligize, because i am a beginner
in this combo box stuff.

oh! and the code i type exactly how debra has it. i even use the same name
that she uses.

about the mouse is not possible or not?

thx.

 

[Dave Peterson]

When you show the properties window to show change the .matchentry property,
look for the .listfillrange and change that to match the name you created.

I don't know a way to select the combobox using only the keyboard. But you can
use the alt-down arrow to see the list. Or use the arrow keys to cycle through
the list.

for the name, you mean the name of the combo box or the name for the data
validation?

to create the name of the combo box, properties, at the top, the name field,
type the name, done.

assign the rowsource, i haven't assign nothing in the combo box, except the
rowlist, that shows you how many options you want the combo box shows in the
dropodown list.

Maybe that is the missing point, a rowsource for the combo box, right? i
just customize the font, the name (i told you what i did), the rowlist(), and
the entrymatch, is there something that i have to cuztomize too?

and what is that of the listfill range? i apoligize, because i am a beginner
in this combo box stuff.

oh! and the code i type exactly how debra has it. i even use the same name
that she uses.

about the mouse is not possible or not?

thx.