+ Reply to Thread
Results 1 to 2 of 2

Combobox Left Align Text that's too long to fit into cell

  1. #1
    Registered User
    Join Date
    07-06-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    7

    Combobox Left Align Text that's too long to fit into cell

    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!

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,651

    Re: Combobox Left Align Text that's too long to fit into cell

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1