ListWidth and ColumnWidths

I

IT_roofer

Hey All,

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

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ComboBox listwidth to match text in list 20
How to autofit text containing CHR(10)? 3
ComboBox.ListWidth question 1
Size Picture to Cell 6
Size a Cell to a Picture 0
Incorporating 2 scripts together that only work separately right now. 1
Problem with hyperlink macro 0
Userform Control validity check 5

Top