Formatting Combo Boxes-Hide the button

  • Thread starter Thread starter rojj
  • Start date Start date
R

rojj

I have created a few combo-boxes in an excel spreadsheet.. Is there a
way to hide the "arrow-button" of the combo box when the sheet is
printed?... I have gone under Format Control > Properties > and
un-checked the print object box...However doing this not only hides the
combo box button, but also does not display the selected text of the
combo-box... I want text selection to show up, but I do not want the
button to show, when it is printed.....

The drop-down boxes (as they are called in Word) do exactly what I am
trying to accomplish, and I am trying to get the same result in
Excel......

So please help, any ideas or suggestions will be greatly
appreciated....
 
If this is a combo box from the Control Toolbox, set its LinkedCell
property to the cell under the combo box. Then, when you print, the
combo box will be hidden, and the cell that contains the combo box
selection will print.
 
Thank you....I looked into the data validation technique, and tha
seemed to give me the desired effect I was looking for... So both o
you who replied, thank you for your suggestions and input..
 
Back
Top