P
phdre
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.
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 som
mitigation circumstances such as having 10 drop down menus in th
worksheet (each on the same row) and that each drop down menu i
comprised of merged cells four columns wide. I was wondering if someon
could point me in a direction that would allow me to find a vba solutio
that would temporarily increase the width of selected drop-down men
columns so that certain words do not run over the width of the column
and consequently some of the options run over the width of the column.
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 som
mitigation circumstances such as having 10 drop down menus in th
worksheet (each on the same row) and that each drop down menu i
comprised of merged cells four columns wide. I was wondering if someon
could point me in a direction that would allow me to find a vba solutio
that would temporarily increase the width of selected drop-down men
columns so that certain words do not run over the width of the column