Thanks, Gord!

Hopefully I'll remember that for future use and in the meantime, I'll save
that url.

--
Biff
Microsoft Excel MVP


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Biff

If you slightly change the URL like so

http://www.contextures.on.ca/excelfiles.html#DV0004

That particular item will be top of page.

No need to scroll down "looking for"


Gord

On Fri, 21 Aug 2009 12:48:55 -0400, "T. Valko"
wrote:

There is a sample file here that shows how to do this:

http://contextures.com/excelfiles.html#DataVal

Look for:

DV0004 - Data Validation Change -- Select a Product from the Data
Validation
list; an event procedure changes the product name to a product code.