I believe that Microsoft limit the number of entries in a drop list to 8
which I find pretty strange

I am now getting to the stage where some of my DD lists are approaching hundreds of entries
which is painful to scroll through

I would be happy to accept a compromise (say 50 entries) so can
anyone advise how to do this (without extensive VBA code which I can do if necessary)
but I'm looking for a simple solution

Thanks in advance

BazzaBit