I'm still learning the basics of VBA. How can I left align (activex) combobox text that's too long to fit into a cell?
When user picks the choice from the dropdown, I would like them to see the whole string of text. However, after the selection is made, I just want to see the left part of the text.
Thank you!
An ActiveX combobox has a ListWidth property. It's default setting is 0pt which means the dropdown list width is the same as the combobox width. If you set it to anything greater than zero (say 300 pt), that will be the dropdown list width.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks