I was given an Excel Program that contains tons of drop-down boxes. Is there a way to make these (in Excel or VBA) so they always show the options in the drop down box instead of the arrow to show the choices?


I have:BlankBox w/ side arrow
Want:A box with all the options always showing

(Basically we want to convert them into more of a command button w/o alot of work)