ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ListWidth and ColumnWidths (https://www.excelbanter.com/excel-programming/394484-listwidth-columnwidths.html)

IT_roofer

ListWidth and ColumnWidths
 
Hey All,

I'm having a bit of trouble coming up with the correct search term so
forgive me if this has been asked befo

I have a combobox with several entries and I want to match the .ListWidth
and .ColumnWidths with the longest entry in the list. I tried using
..ListWidth = .TextLength but the result was a dropdown about 10 points wide!
=/

I think I need a loop... anyone have any ideas?


All times are GMT +1. The time now is 10:39 AM.

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