Combo box 2 columns
 

Hi ng.
Using xl xp pro

Added ActiveX Combo Box to my worksheet
Col count = 2
Col Widths = 15 pt
List Fill Range = $A$50:$B$186

Col A contains account numbers: 60011560
Col B contains descriptions: Meat / Cheese

When I exit design and click on down arrow 1st column is very narrow
2nd column is very wide.

How can I balance so I can see both columns equally

--
Message posted from http://www.ExcelForum.com

Combo box 2 columns
 

Delete the contents of the "Widths" property. Excel will adjust them
automatically.

--
Regards

Juan Pablo González

"goss " wrote in message
...
Hi ng.
Using xl xp pro

Added ActiveX Combo Box to my worksheet
Col count = 2
Col Widths = 15 pt
List Fill Range = $A$50:$B$186

Col A contains account numbers: 60011560
Col B contains descriptions: Meat / Cheese

When I exit design and click on down arrow 1st column is very narrow.
2nd column is very wide.

How can I balance so I can see both columns equally?


---
Message posted from http://www.ExcelForum.com/

Combo box 2 columns
 

Sweet! Thanks!

Column Widths though not Widt

--
Message posted from http://www.ExcelForum.com