I've downloaded the test(2) file from this thread:
making dropdown list wider without making cell wider ???
Sorry I'm unable to link as this is my first post.
It was the perfect solution to what I need. All I had to do was modify the code to my desired columns and the widths of the columns. I also changed the name of module to ExpandedCell But for some reason it doesn't work. I've struggled for hours and have given up.
Attached is the exact routine which I modified and my file.
Customer Documents & Databases.xlsmPlease Login or Register to view this content.
Bookmarks