Insert Drop Down List

  • Thread starter Thread starter Rescueme
  • Start date Start date
R

Rescueme

I want to insert into a merged cell a drop-down list that will allow me to
choose between 3 items of text and populate the cell. I want the printed
version to not show the drop down box only the selected item. Is this
possible? The three text choices would be PACKING SLIP, ORDER CONFIRMATION,
INVOICE.

Thanks,
Karen
 
Use the Data Validation Command. From the Data menu:
- Select Validation.
- In the Allow list box, select "List"
- In the Source list box, enter your three choices, separated by commas.

If you're just looking for a faster/easier way to input, enable the
AutoComplete setting. This can be done from the Tools menu, Options, Edit
tab. (No list box.)

If you're looking at a VBA solution, set the PrintObject property to FALSE.
 
Back
Top