Combo Change

[JUALOP60]

Hi,

How to make combo box size to chane when click arrow, and then go back to normal size?

will this code work:

ComboBox1.Width = 200 how to get it back to normal size
one i select the item.

because the way it is now i can not see all columns only if I scroll to the right.

thank you

 

[dhookom]

If this question is regarding Access, you can set the column widths property so the dropped width is much wider than the non-dropped size. No code needed.

Duane
Hook'D on Access
MS Access MVP

 

[JUALOP60]

Sorry, I forgot to mention, Excel 2007.

thank you

 

[JUALOP60]

Thank you.

You were right dhookom I didn't need a code, just needed to
put list width number in the combo box.


Thank you again