program drop-down boxes in excel
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)
Re: program drop-down boxes in excel
No, a combo box (drop down box) is designed to show only one choice until its clicked on to drop down the rest of its choices. Sounds like you may want to replace the combo boxes with listboxes but then allot of code will probably need changing too.