ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   No printing of drop down box? (https://www.excelbanter.com/excel-discussion-misc-queries/171739-re-no-printing-drop-down-box.html)

Dave Peterson

No printing of drop down box?
 
Right click on the dropdown or combobox.
Choose Format Control
On the Properties tab, uncheck the "Print object" box.

Al wrote:

Is there a way to use a drop down box in a cell but not have it priint the
box just the value selected?


--

Dave Peterson

Dave Peterson

No printing of drop down box?
 
ps. Depending on what type of dropdown/combobox you used, you could use a
linked cell that's directly under the combobox to see what was chosen.

Dave Peterson wrote:

Right click on the dropdown or combobox.
Choose Format Control
On the Properties tab, uncheck the "Print object" box.

Al wrote:

Is there a way to use a drop down box in a cell but not have it priint the
box just the value selected?


--

Dave Peterson


--

Dave Peterson

al

No printing of drop down box?
 
Wow!
That was easy!
Thanks!

"Dave Peterson" wrote:

ps. Depending on what type of dropdown/combobox you used, you could use a
linked cell that's directly under the combobox to see what was chosen.

Dave Peterson wrote:

Right click on the dropdown or combobox.
Choose Format Control
On the Properties tab, uncheck the "Print object" box.

Al wrote:

Is there a way to use a drop down box in a cell but not have it priint the
box just the value selected?


--

Dave Peterson


--

Dave Peterson



All times are GMT +1. The time now is 09:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com