Is there a way to get cells to auto-fill while a person is typing? For
example, if I have a cell that has a drop-down list with the options:

Apple
Artichoke
Banana
Cantaloupe
Cucumber
Celery

If I start to type "C" into the cell, I want it to realize, "Hey, there are
three C-options in this list. Perhaps I should choose one of those." Or, in
this case, since there are more than one, then if a person were to type "Ca,"
I would want Excel to realize they are typing Cantaloupe and fill in the rest
of the word for them.

I have created a huge spreadsheet template for a client and she wants to be
able to quickly enter information without having to type the whole word (some
of these cells contain options with 8-10 words per selection) and without
having to resort to using the drop-down menus constantly.

Also, in cases where I have a list like:

Yes
No
Maybe
N/A

....when she starts to type in "Yes," the cell does not pick that up. If she
types in "yes" with the lower-case Y, Excel still accepts it and will leave
it lower-case, even though the Data Validation cell has a capital Y. Is
there a way to fix that?

Thank you!

Also, I forgot to mention that even with AutoComplete on, this is still
happening to me. She is working in 2003 and I'm working in 2007 with the
Compatibility Mode on.

"Oriana" wrote:

Is there a way to get cells to auto-fill while a person is typing? For
example, if I have a cell that has a drop-down list with the options:

Apple
Artichoke
Banana
Cantaloupe
Cucumber
Celery

If I start to type "C" into the cell, I want it to realize, "Hey, there are
three C-options in this list. Perhaps I should choose one of those." Or, in
this case, since there are more than one, then if a person were to type "Ca,"
I would want Excel to realize they are typing Cantaloupe and fill in the rest
of the word for them.

I have created a huge spreadsheet template for a client and she wants to be
able to quickly enter information without having to type the whole word (some
of these cells contain options with 8-10 words per selection) and without
having to resort to using the drop-down menus constantly.

Also, in cases where I have a list like:

Yes
No
Maybe
N/A

...when she starts to type in "Yes," the cell does not pick that up. If she
types in "yes" with the lower-case Y, Excel still accepts it and will leave
it lower-case, even though the Data Validation cell has a capital Y. Is
there a way to fix that?

Thank you!

DV dropdowns do not have the autocomplete feature.

You would have to use a combobox for that.

See Debra Dalgeish's site for help

For the combobox solution see

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP


On Wed, 14 May 2008 07:46:05 -0700, Oriana
wrote:

Is there a way to get cells to auto-fill while a person is typing? For
example, if I have a cell that has a drop-down list with the options:

Apple
Artichoke
Banana
Cantaloupe
Cucumber
Celery

If I start to type "C" into the cell, I want it to realize, "Hey, there are
three C-options in this list. Perhaps I should choose one of those." Or, in
this case, since there are more than one, then if a person were to type "Ca,"
I would want Excel to realize they are typing Cantaloupe and fill in the rest
of the word for them.

I have created a huge spreadsheet template for a client and she wants to be
able to quickly enter information without having to type the whole word (some
of these cells contain options with 8-10 words per selection) and without
having to resort to using the drop-down menus constantly.

Also, in cases where I have a list like:

Yes
No
Maybe
N/A

...when she starts to type in "Yes," the cell does not pick that up. If she
types in "yes" with the lower-case Y, Excel still accepts it and will leave
it lower-case, even though the Data Validation cell has a capital Y. Is
there a way to fix that?

Thank you!

Are there instructions on how to do this in 2007? I cannot find half of the
toolbars in the instructions. I was able to sort've locate the combo box,
but I can't find the properties option.

"Gord Dibben" wrote:

DV dropdowns do not have the autocomplete feature.

You would have to use a combobox for that.

See Debra Dalgeish's site for help

For the combobox solution see

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP


On Wed, 14 May 2008 07:46:05 -0700, Oriana
wrote:

Is there a way to get cells to auto-fill while a person is typing? For
example, if I have a cell that has a drop-down list with the options:

Apple
Artichoke
Banana
Cantaloupe
Cucumber
Celery

If I start to type "C" into the cell, I want it to realize, "Hey, there are
three C-options in this list. Perhaps I should choose one of those." Or, in
this case, since there are more than one, then if a person were to type "Ca,"
I would want Excel to realize they are typing Cantaloupe and fill in the rest
of the word for them.

I have created a huge spreadsheet template for a client and she wants to be
able to quickly enter information without having to type the whole word (some
of these cells contain options with 8-10 words per selection) and without
having to resort to using the drop-down menus constantly.

Also, in cases where I have a list like:

Yes
No
Maybe
N/A

...when she starts to type in "Yes," the cell does not pick that up. If she
types in "yes" with the lower-case Y, Excel still accepts it and will leave
it lower-case, even though the Data Validation cell has a capital Y. Is
there a way to fix that?

Thank you!

Well, I found the properties, but it doesn't offer font changes, I can't name
it, etc. The ListRows and all that stuff isn't available, either. Perhaps
they have disabled this for 2007?

"Gord Dibben" wrote:

DV dropdowns do not have the autocomplete feature.

You would have to use a combobox for that.

See Debra Dalgeish's site for help

For the combobox solution see

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP


On Wed, 14 May 2008 07:46:05 -0700, Oriana
wrote:

Is there a way to get cells to auto-fill while a person is typing? For
example, if I have a cell that has a drop-down list with the options:

Apple
Artichoke
Banana
Cantaloupe
Cucumber
Celery

If I start to type "C" into the cell, I want it to realize, "Hey, there are
three C-options in this list. Perhaps I should choose one of those." Or, in
this case, since there are more than one, then if a person were to type "Ca,"
I would want Excel to realize they are typing Cantaloupe and fill in the rest
of the word for them.

I have created a huge spreadsheet template for a client and she wants to be
able to quickly enter information without having to type the whole word (some
of these cells contain options with 8-10 words per selection) and without
having to resort to using the drop-down menus constantly.

Also, in cases where I have a list like:

Yes
No
Maybe
N/A

...when she starts to type in "Yes," the cell does not pick that up. If she
types in "yes" with the lower-case Y, Excel still accepts it and will leave
it lower-case, even though the Data Validation cell has a capital Y. Is
there a way to fix that?

Thank you!

I'm sorry for all of the messages.

I found that I have to use the ActiveX combo box rather than the form
control ones.

However, I have done everything those instructions told me to and I don't
see how that helped. The combo box just sits there and doesn't seem to serve
a purpose? Whenever I type in a cell that has data validation in it, it
still doesn't autocomplete while I type.

"Gord Dibben" wrote:

DV dropdowns do not have the autocomplete feature.

You would have to use a combobox for that.

See Debra Dalgeish's site for help

For the combobox solution see

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP


On Wed, 14 May 2008 07:46:05 -0700, Oriana
wrote:

Is there a way to get cells to auto-fill while a person is typing? For
example, if I have a cell that has a drop-down list with the options:

Apple
Artichoke
Banana
Cantaloupe
Cucumber
Celery

If I start to type "C" into the cell, I want it to realize, "Hey, there are
three C-options in this list. Perhaps I should choose one of those." Or, in
this case, since there are more than one, then if a person were to type "Ca,"
I would want Excel to realize they are typing Cantaloupe and fill in the rest
of the word for them.

I have created a huge spreadsheet template for a client and she wants to be
able to quickly enter information without having to type the whole word (some
of these cells contain options with 8-10 words per selection) and without
having to resort to using the drop-down menus constantly.

Also, in cases where I have a list like:

Yes
No
Maybe
N/A

...when she starts to type in "Yes," the cell does not pick that up. If she
types in "yes" with the lower-case Y, Excel still accepts it and will leave
it lower-case, even though the Data Validation cell has a capital Y. Is
there a way to fix that?

Thank you!

Works fine when I follow the steps on Debra's site.

Did you copy all the worksheet code to the sheet module?

Have you exited Design Mode?

Have you double-clicked on the the DV dropdown cell?

Did you download the sample file to have a look at a working model?


Gord

On Wed, 14 May 2008 09:47:03 -0700, Oriana
wrote:

I'm sorry for all of the messages.

I found that I have to use the ActiveX combo box rather than the form
control ones.

However, I have done everything those instructions told me to and I don't
see how that helped. The combo box just sits there and doesn't seem to serve
a purpose? Whenever I type in a cell that has data validation in it, it
still doesn't autocomplete while I type.

"Gord Dibben" wrote:

DV dropdowns do not have the autocomplete feature.

You would have to use a combobox for that.

See Debra Dalgeish's site for help

For the combobox solution see

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP


On Wed, 14 May 2008 07:46:05 -0700, Oriana
wrote:

Is there a way to get cells to auto-fill while a person is typing? For
example, if I have a cell that has a drop-down list with the options:

Apple
Artichoke
Banana
Cantaloupe
Cucumber
Celery

If I start to type "C" into the cell, I want it to realize, "Hey, there are
three C-options in this list. Perhaps I should choose one of those." Or, in
this case, since there are more than one, then if a person were to type "Ca,"
I would want Excel to realize they are typing Cantaloupe and fill in the rest
of the word for them.

I have created a huge spreadsheet template for a client and she wants to be
able to quickly enter information without having to type the whole word (some
of these cells contain options with 8-10 words per selection) and without
having to resort to using the drop-down menus constantly.

Also, in cases where I have a list like:

Yes
No
Maybe
N/A

...when she starts to type in "Yes," the cell does not pick that up. If she
types in "yes" with the lower-case Y, Excel still accepts it and will leave
it lower-case, even though the Data Validation cell has a capital Y. Is
there a way to fix that?

Thank you!

I messed around with the sample file on that website and I can see how it
works a little better. However, whenever I try to type in one of the combo
boxes, I get an error in the code. For example, I tried typing "B" to start
typing "Behavior" and it popped up the macro screen with the error: "Compile
error: Only comments may appear after End Sub, End Fuction, or End Property"
I click OK and it then highlights the following near the very end of the code:

Private Sub TempCombo_KeyDown(ByVal _ KeyCode As MSForms.ReturnInteger, _
ByVal Shift As Integer)



"Gord Dibben" wrote:

Works fine when I follow the steps on Debra's site.

Did you copy all the worksheet code to the sheet module?

Have you exited Design Mode?

Have you double-clicked on the the DV dropdown cell?

Did you download the sample file to have a look at a working model?


Gord

On Wed, 14 May 2008 09:47:03 -0700, Oriana
wrote:

I'm sorry for all of the messages.

I found that I have to use the ActiveX combo box rather than the form
control ones.

However, I have done everything those instructions told me to and I don't
see how that helped. The combo box just sits there and doesn't seem to serve
a purpose? Whenever I type in a cell that has data validation in it, it
still doesn't autocomplete while I type.

"Gord Dibben" wrote:

DV dropdowns do not have the autocomplete feature.

You would have to use a combobox for that.

See Debra Dalgeish's site for help

For the combobox solution see

http://www.contextures.on.ca/xlDataVal10.html


Gord Dibben MS Excel MVP


On Wed, 14 May 2008 07:46:05 -0700, Oriana
wrote:

Is there a way to get cells to auto-fill while a person is typing? For
example, if I have a cell that has a drop-down list with the options:

Apple
Artichoke
Banana
Cantaloupe
Cucumber
Celery

If I start to type "C" into the cell, I want it to realize, "Hey, there are
three C-options in this list. Perhaps I should choose one of those." Or, in
this case, since there are more than one, then if a person were to type "Ca,"
I would want Excel to realize they are typing Cantaloupe and fill in the rest
of the word for them.

I have created a huge spreadsheet template for a client and she wants to be
able to quickly enter information without having to type the whole word (some
of these cells contain options with 8-10 words per selection) and without
having to resort to using the drop-down menus constantly.

Also, in cases where I have a list like:

Yes
No
Maybe
N/A

...when she starts to type in "Yes," the cell does not pick that up. If she
types in "yes" with the lower-case Y, Excel still accepts it and will leave
it lower-case, even though the Data Validation cell has a capital Y. Is
there a way to fix that?

Thank you!

You should have copied all the code including this last bit.

Private Sub TempCombo_KeyDown(ByVal _
KeyCode As MSForms.ReturnInteger, _
ByVal Shift As Integer)
Select Case KeyCode
Case 9 'Tab
ActiveCell.Offset(0, 1).Activate
Case 13 'Enter
ActiveCell.Offset(1, 0).Activate
Case Else
'do nothing
End Select
End Sub

Sounds to me like you have missed some of the above or entered some text below
the End Sub line.


Gord

On Wed, 14 May 2008 11:43:01 -0700, Oriana
wrote:

I messed around with the sample file on that website and I can see how it
works a little better. However, whenever I try to type in one of the combo
boxes, I get an error in the code. For example, I tried typing "B" to start
typing "Behavior" and it popped up the macro screen with the error: "Compile
error: Only comments may appear after End Sub, End Fuction, or End Property"
I click OK and it then highlights the following near the very end of the code:

Private Sub TempCombo_KeyDown(ByVal _ KeyCode As MSForms.ReturnInteger, _
ByVal Shift As Integer)