Is there any way to subvert autocomplete so that it does it's looking up in
a range other than the active column?

The effect I'm trying to achieve is have a list of names in one place, list
A, and have the user entering names in another, list B, but have the auto
complete use list A for doing the autocomplete and not list B.

I realize with some really ugly and massive use of OnKey and AutoComplete I
can give the illusion of this but that's unacceptable. I want to subvert
Excel's built in feature.

--
Terry

"I said I never had much use for one,
I never said I didn't know how to use one."
M. Quigley

also asked in msp.excel

--
Don Guillett
SalesAid Software

"Terry von Gease" wrote in message
...
Is there any way to subvert autocomplete so that it does it's looking up
in
a range other than the active column?

The effect I'm trying to achieve is have a list of names in one place,
list
A, and have the user entering names in another, list B, but have the auto
complete use list A for doing the autocomplete and not list B.

I realize with some really ugly and massive use of OnKey and AutoComplete
I
can give the illusion of this but that's unacceptable. I want to subvert
Excel's built in feature.

--
Terry

"I said I never had much use for one,
I never said I didn't know how to use one."
M. Quigley

So? Excuse the hell out of me if I nudged some tribal taboo or another. I'm
just looking for an answer. Do you have one?

Does anyone? Anyone? Anyone? Bueller? Anyone?

--
Terry

"I said I never had much use for one,
I never said I didn't know how to use one."
M. Quigley

"Don Guillett" wrote in message
...
also asked in msp.excel

--
Don Guillett
SalesAid Software

"Terry von Gease" wrote in message
...
Is there any way to subvert autocomplete so that it does it's looking up
in
a range other than the active column?

The effect I'm trying to achieve is have a list of names in one place,
list
A, and have the user entering names in another, list B, but have the
auto
complete use list A for doing the autocomplete and not list B.

I realize with some really ugly and massive use of OnKey and
AutoComplete
I
can give the illusion of this but that's unacceptable. I want to subvert
Excel's built in feature.

--
Terry

"I said I never had much use for one,
I never said I didn't know how to use one."
M. Quigley

Don't believe it is subvertable.

--
Regards,
Tom Ogilvy


Terry von Gease wrote in message
...
So? Excuse the hell out of me if I nudged some tribal taboo or another.
I'm
just looking for an answer. Do you have one?

Does anyone? Anyone? Anyone? Bueller? Anyone?

--
Terry

"I said I never had much use for one,
I never said I didn't know how to use one."
M. Quigley

"Don Guillett" wrote in message
...
also asked in msp.excel

--
Don Guillett
SalesAid Software

"Terry von Gease" wrote in message
...
Is there any way to subvert autocomplete so that it does it's looking
up
in
a range other than the active column?

The effect I'm trying to achieve is have a list of names in one place,
list
A, and have the user entering names in another, list B, but have the
auto
complete use list A for doing the autocomplete and not list B.

I realize with some really ugly and massive use of OnKey and
AutoComplete
I
can give the illusion of this but that's unacceptable. I want to
subvert
Excel's built in feature.

--
Terry

"I said I never had much use for one,
I never said I didn't know how to use one."
M. Quigley

That was what I suspected. Too bad. It leaves a choice between doing without
or some Really Ugly code. I think we'll do without. Thanks.

--
Terry

"I said I never had much use for one,
I never said I didn't know how to use one."
M. Quigley

"Tom Ogilvy" wrote in message
...
Don't believe it is subvertable.

--
Regards,
Tom Ogilvy


Terry von Gease wrote in message
...
So? Excuse the hell out of me if I nudged some tribal taboo or another.
I'm
just looking for an answer. Do you have one?

Does anyone? Anyone? Anyone? Bueller? Anyone?

--
Terry

"I said I never had much use for one,
I never said I didn't know how to use one."
M. Quigley

"Don Guillett" wrote in message
...
also asked in msp.excel

--
Don Guillett
SalesAid Software

"Terry von Gease" wrote in message
...
Is there any way to subvert autocomplete so that it does it's
looking
up
in
a range other than the active column?

The effect I'm trying to achieve is have a list of names in one
place,
list
A, and have the user entering names in another, list B, but have the
auto
complete use list A for doing the autocomplete and not list B.

I realize with some really ugly and massive use of OnKey and
AutoComplete
I
can give the illusion of this but that's unacceptable. I want to
subvert
Excel's built in feature.

--
Terry

"I said I never had much use for one,
I never said I didn't know how to use one."
M. Quigley