I already did this before but the combo box doesn't do the same thing it
does for the sample, no autocomplete.. etc. I'm thinking that the VBA code
may need a little tweaking.

"Gord Dibben" wrote:

Name the list under InsertNameDefine.

Call it MyList.

Then in DV source dialog enter =MyList


Gord Dibben MS Excel MVP

On Fri, 5 Jan 2007 18:51:01 -0800, fLy wrote:

This sample:
http://www.contextures.com/xlDataVal10.html
used a list located in the same worksheet. I want to apply this on a list
that is located on another worksheet. What changes should I make?