David / Anne

Thanks fo0r the feedback - I have worked out how to have drop downs starting
at top when starting from a blank cell - first line of data block needs to be
blank.

Have not worked out how to zoom - other than my upping manula zoom which I
do not really want to do.


Combo box sounds interesting - I'll have a play.

Thanks for your help.

Andy



"David" wrote:

?B?QW5keSBC?= wrote

is it possible to make a drop down list box bigger?

Not without setting the Zoom higher, either manually or via macro code
invoked when that cell is selected.

Is it possible to make the drop down list box always start at the first
entry in the lst rather then the last one selected?

Not that I've found with a Data Validation dropdown, but you can make a
userform using a combo box and initialize it to select the top one every
time.

Others will have to jump in to provide actual macro code or websites that
explain in more detail. My plate is too full.

--
David