Hi I am creating a user form with dropdown boxes that show text but lookup numeric values and add a numeric value in the very narrow spreadsheet column, my problem is when you dropdown the box the view (width) is very limited and you cant see the full text ? Can I change this to expand just the dropdown view box?
If you create the comboboxes on the userform manually, then you can set the columnwidths property in the properties box by typing in the desired width in points, cm or in like.
90 ( if points not text is needed), 2.54 cm or 1.5 in.
If you are creating them in VBA and want to set the widths Then
If the combobox is multicolumn, then separate the columns with semicolons
Please Login or Register to view this content.
"90; 50; 75" Or "2.54 cm; 1.12 cm; 2 cm"
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
I have just created the dropdowns by data validation problem.jpg
The bonus of doing like JLGWhiz suggests is that you get a visible box for users to select (as well as being able to customise the width as he describes). These do not print so wouldn't affect appearance.
Worth a shot to see if it suits you or not, as I do not know of a way to resize a drop down list beyond that which the cell is already formatted to.
The column width of a validation drop down is based on the column width of the host cell. So if you want to expand the dropdown width, increase the column width.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks