Printing forms

[o.sroubek]

Once a form is ready for printing and was created with
for ex a combo box or list box, is it possible to have
the final print not showing the arrow and the box and
just the information chosen inside the box?

 

[JE McGimpsey]

Once a form is ready for printing and was created with
for ex a combo box or list box, is it possible to have
the final print not showing the arrow and the box and
just the information chosen inside the box?

One way (well, a workaround really):

Assume your input range is named input_range, your cell link is named
cell_link. Then in the cell *under* the combobox enter

=INDEX(input_range,cell_link)

and set the combobox not to print (Format/Control/Properties, uncheck
the print checkbox).

 

[o.sroubek]

Thanks. It sound kind of complicated. I'm not too
familiar with this program. I had done something similar
in Word using form fields and drop down boxes. The shaded
fields would not get printed, only what was selected.
Thank you

-----Original Message-----


One way (well, a workaround really):

Assume your input range is named input_range, your cell link is named
cell_link. Then in the cell *under* the combobox enter

=INDEX(input_range,cell_link)

and set the combobox not to print

(Format/Control/Properties, uncheck

 

[JE McGimpsey]

Thanks. It sound kind of complicated. I'm not too
familiar with this program. I had done something similar
in Word using form fields and drop down boxes. The shaded
fields would not get printed, only what was selected.

It's really not that complicated: You already have a combobox,
presumably with an inputrange and a linked cell. What I suggested
involves

a) one additional formula, and

b) unchecking one checkbox in the Format/Control/Properties tab.

Form fields in Word are much more difficult (at least for me...)