ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Combo Box Print issue (https://www.excelbanter.com/excel-programming/375581-combo-box-print-issue.html)

Jack_Feeman

Combo Box Print issue
 
I have a combo box filled with choices. I want to print the selected choice
but not the object. Setting PrintObject to True prints the box (and selection
of course) but setting it to False does not print anything.

How do I print only the selected text and not the object also.

Thanks
Jack

Tom Ogilvy

Combo Box Print issue
 
Link it to the cell underneath and set printobject to false.

--
Regards,
Tom Ogilvy



"Jack_Feeman" wrote:

I have a combo box filled with choices. I want to print the selected choice
but not the object. Setting PrintObject to True prints the box (and selection
of course) but setting it to False does not print anything.

How do I print only the selected text and not the object also.

Thanks
Jack


Jack_Feeman

Combo Box Print issue
 
Great Tom, and thanks for the very quick response!

"Tom Ogilvy" wrote:

Link it to the cell underneath and set printobject to false.

--
Regards,
Tom Ogilvy



"Jack_Feeman" wrote:

I have a combo box filled with choices. I want to print the selected choice
but not the object. Setting PrintObject to True prints the box (and selection
of course) but setting it to False does not print anything.

How do I print only the selected text and not the object also.

Thanks
Jack



All times are GMT +1. The time now is 12:24 PM.

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