Reference:http://www.excelforum.com/showthread.php?t=602844
Dear Experts
On UserForm1, Combobox1 has two columns with data as follows
1 ASIA FLOUR MILLS BAHAWALPUR
2 AZIZ FLOUR MILLS BAHAWALPUR
When I dropdown the list then column2 does not display complete data.
I mean it show first line as
1 ASIA FLO
How to force listbox to autofit columns.
When I dropdown the combo then listbox should automatically wide.
The attachment is Source sheet and Userform with combbox.
Please help