This is a one-time use kind of thing, but great for future learning for
myself. There are no typos, I'm sure of that :-D

"Gord Dibben" wrote:

You mean you want the code you typed in to be overwritten by the description?

Sounds a little dangerous to me.

How do you account for errors in typing?

You could use event code using Case Select I suppose but with many item codes
that could become quite lengthy.

One of the VBA guru's will come up with something loopy, I'm sure.


Gord

On Wed, 15 Nov 2006 15:48:01 -0800, jweasl
wrote:

Hi Gord!
I'm pretty familiar with Vlookup and Data Validation - I already use that in
another instance - but my issue here is I want to type in a cell and then
have the same cell's contents change. Looks like I need a Loop function, and
I have no experience with those :-(

"Gord Dibben" wrote:

Check out help on VLOOKUP tables.

Also see Debra Dalgleish's site for more(and better) on VLOOKUP and Data
Validation lists for entering the item code.

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

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


Gord Dibben MS Excel MVP


On Wed, 15 Nov 2006 15:20:01 -0800, jweasl
wrote:

I have a large list of items - what I would like is when someone enters the
item code, the rest of the information (description, etc) fills in. I know I
can do this with AutoComplete - just wondering if there is a better way since
I am using a large list and don't want to type in each item description by
hand.