So I have ten drop down menus in my worksheet which have lots of text, and consequently some of the options run over the width of the column. I am looking for a VBA solution to this and stumbled across this site: http://www.contextures.com/xlDataVal08.html#Wider
It seems that this would be a good solution, however I have some mitigation circumstances such as having 10 drop down menus in the worksheet (each on the same row) and that each drop down menu is comprised of merged cells four columns wide. I was wondering if someone could point me in a direction that would allow me to find a vba solution that would temporarily increase the width of selected drop-down menu columns so that certain words do not run over the width of the column.