Posted to microsoft.public.excel.programming

external usenet poster

Posts: 45

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Setting columnwidths	Jason Zischke	Excel Programming	5	July 1st 07 07:00 AM
ColumnWidths property	Tom	Excel Programming	4	April 11th 06 09:33 AM
PasteSpecial Paste:=ColumnWidths	Arvi Laanemets	Excel Programming	3	February 8th 05 01:46 PM
listbox.Columnwidths question	Stuart[_5_]	Excel Programming	1	September 21st 03 07:26 PM
ComboBox.ListWidth question	Joepy	Excel Programming	1	September 5th 03 04:50 PM

All times are GMT +1. The time now is 03:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us