Use a ComboBox.

See Debra Dalgleish's site.

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


Gord Dibben MS Excel MVP

On Mon, 22 Jun 2009 10:11:01 -0700, christin
wrote:

The work around to increase the zoom everytime a DV is used is not a good
remedy for my specific worksheet. Isn't there another answer?