I have inherited a workbook which in the 1st sheet is an the input selections for the other sheets.
Currently many of the selections require the user to selection items from a combo box (form control) and it all works well, but when printed the font in the box's is too small. I had a look to see if I could change the font size and it would appear that you can only change the font size on an Active X combo box.
That seemed simple enough so I started changing the boxes over... However the form control boxes outputs a number not the selection, the active X box results is the selection... IE If you select Black from a list of colours and black is 3rd in the list the form control box reports 3 in the desired cell active x reports black.
All I wanted was to make the text in the selection boxes legible when printed, but I'm going to have to rework the whole workbook unless there is a better way or I can fix the output of the active x combo box
Thanks in advance if anyone can help