View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
IT_roofer IT_roofer is offline
external usenet poster
 
Posts: 45
Default 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?