Stop the Combo box triangle from printing

B

BCPete

I've created a Duty Roster form that has multiple dropdown boxes for all of
the emploees to be placed on the form. All of these triangles showing on the
form are distracting. One can activate the dropdown list in the box by
clicking on the box, not necessarily on the triangle, so can I hide the
triangle? I've tried everything I can, but nothing works. If I say "Don't
print" the object, then the contents are also not printed...

Thanks
Pete
 
T

TK

Try using data validation instead of combo boxes.

If you select the "List" option you can create the
appearance of a combo box that looks like a regular cell
until you select it, but then it works as a combo box for
data entry. After leaving the cell it will appear as a
regular cell... and also when printed.

Also, keep in mind that all combo-boxes are not created
equal; combo boxes (and other objects) created with
the "Controls Toolbox" are ActiveX controls, and can be
more flexible to modify with code than similar command
objects created with the "Forms" toolbar, but I am not
aware of a way to hide the triangles in either of these
combo boxes.


HTH,

TK
 
D

Dave Peterson

How did you make the dropdown?

If you used the combobox from the control toolbox toolbar, maybe you could cheat
a little.

Make the linked cell the cell that's covered by the combobox.

If you have to have the linked cell somewhere else, just use a formula that
points at it:

=if(sheet2!a1="","",sheet2!a1)

If you used a dropdown from the Forms toolbar, the cell link returns an index
into list.

If you used a worksheet range as your list, you could use the cell link and list
to get the value:

=if(sheet2!a1="","",index(sheet2!b1:b10,sheet2!a1))

(and still tell excel not to print the combobox/dropdown).
 
D

Debra Dalgleish

If these are combo boxes from the Control toolbox, you can do the following:

Switch to Design Mode (click the Design Mode button on
the Control toolbox)
Select the combo box, and click the Properties button
on the Control toolbox
Set ShowDropButtonWhen to 1-fmShowDropButtonWhenFocus
To hide the combobox borders, set SpecialEffect to 0-fmSpecialEffectFlat
 
Top