tqm1
06-08-2007, 12:59 AM
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
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