Predict based on range or series
 

Hi.

I have a series of numbers in a list. I am requiring people to fill in
a block which has these same numbers however, I am trying to cut down
on the time they spend entering the numbers. I know how to set up
validation to have a dropdown box however, this gets back into a time
issue when they have to stop keying and start scrolling.

Is there a code that I could use to enfore predictive text within a
column based on the values within another range?

Excel does this on its own sometimes if you have similar names in the
rows (of the same continuous column) above. I just need to know how to
'force' predictive text when someone is keying in a number that
already exist.

Example:
123456
789012
345678
901234
567890

when someone types "123"
I want them to be able to see that the most likely remaining numbers
in that series is "...456"
.. From there, they can hit enter and move on to the next cell.

Hope this is makes sense....

thanx

Predict based on range or series
 

Look up the AutoComplete property in VBA help.

"J.W. Aldridge" wrote:

Hi.

I have a series of numbers in a list. I am requiring people to fill in
a block which has these same numbers however, I am trying to cut down
on the time they spend entering the numbers. I know how to set up
validation to have a dropdown box however, this gets back into a time
issue when they have to stop keying and start scrolling.

Is there a code that I could use to enfore predictive text within a
column based on the values within another range?

Excel does this on its own sometimes if you have similar names in the
rows (of the same continuous column) above. I just need to know how to
'force' predictive text when someone is keying in a number that
already exist.

Example:
123456
789012
345678
901234
567890

when someone types "123"
I want them to be able to see that the most likely remaining numbers
in that series is "...456"
.. From there, they can hit enter and move on to the next cell.

Hope this is makes sense....

thanx