Just to reiterate, a validation list can hold 70 values it is simply restricted in so far as

a) it can only display 8 rows at any given time

b) it does not have auto complete feature

Re: User Form - VBA is a necessity I'm afraid.