Change width of a dropdown list

Hi all,

I am trying to change the width of one specific column where i have a drop down list and i want all the text to be readable when making the choice in the list.

I have tried the solution by contexture (http://www.contextures.com/xlDataVal08.html#Wider)

Please Login or Register  to view this content.

I want the width of the column to change when i click the arrow of the drop down list so when people are about to make the choice in the list it appears wider and therefor increase the readability. Not just when clicking a cell in that column.

Is this possible in some way? Hope someone could help me out!

/Masun

Thanks for the suggestion. Maybe thats a good idea, you are very often spot on, the trouble here, for me that is, i am not able to produce a vba code of your suggestion cause i really dont have that knowledge. But its important for me that the column, and therefor the drop down list, resizes when clicking on the drop down list arrow, not just when clicking on the cell. I dont understand if it will end up in that way with your suggestion?

That sounds fair. ;-)

Seriously...thank you very much!

Hi,

I am getting some compilation error. I guess it has to do with an other drop down list related code im using from contexture. Could you please take a look?

The other macro makes it possible to choose multiple items from the drop down list. In this case colum nr 6...