Combo box 2 columns

G

goss

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
 
J

Juan Pablo González

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cascading Combo Box - help needed please. 6
List Box + Sharepoint Navigation 0
Ribbon X macro not available 2
combo boxes 1
Display info in Combo box'es 2
Combo box help 0
Resubmit of Macro needed to search 2 columns 5
2 Dim Array Sort, on any columns, ascend or descend. Guidance des 0

Top