ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Combo box property (https://www.excelbanter.com/excel-programming/315120-combo-box-property.html)

dan

Combo box property
 
My current combo box is long enough to display my VBA
coded "AddItem" list but when I pull down and view my list
in the combo box the text is cut off. Which combo box
property do I use to adjust the "viewable" text width in
the combo box w/o changing the with of the actual combo
box?

Bear with me I am a beginner! Thanks.

Frank Kabel

Combo box property
 
Hi
try the columnwidth property

--
Regards
Frank Kabel
Frankfurt, Germany

"Dan" schrieb im Newsbeitrag
...
My current combo box is long enough to display my VBA
coded "AddItem" list but when I pull down and view my list
in the combo box the text is cut off. Which combo box
property do I use to adjust the "viewable" text width in
the combo box w/o changing the with of the actual combo
box?

Bear with me I am a beginner! Thanks.



dan

Combo box property
 
I found the solution...Data ColumnWidth!


-----Original Message-----
My current combo box is long enough to display my VBA
coded "AddItem" list but when I pull down and view my

list
in the combo box the text is cut off. Which combo box
property do I use to adjust the "viewable" text width in
the combo box w/o changing the with of the actual combo
box?

Bear with me I am a beginner! Thanks.
.



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

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