Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: combo box arrow

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is it possible to move the arrow in a combo box to the left side of the box instead of the right? (no VBA please)

  2. #2
    MrExcel MVP Joe Was's Avatar
    Join Date
    Feb 2002
    Location
    Central Florida, USA
    Posts
    7,539
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    No

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there any way to move the arrow on the combo box to the left?

  4. #4
    MrExcel MVP Joe Was's Avatar
    Join Date
    Feb 2002
    Location
    Central Florida, USA
    Posts
    7,539
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Not that I know of? JSW

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    119
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This may work for you. Put a combobox in and adjust the size so that you only see the arrow. Now put a textbox on the right side of keeping the proportions similar. Now link the data selection in combobox to the list box.
    VBA: TextBox1.Text = ComboBox1.Text
    Just an idea.
    No VBA then use linked cell= to point to a cell in worksheet for both boxes.

    [ This Message was edited by: d-alan on 2002-03-27 14:42 ]

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,940
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just to add to JSW's reply. There's no way to change this without VBA. I just checked in Dan Appleman's Win32 API guide (which describes practically every possible thing you can do to a combobox) to see if it could even be done through VBA and there's nothing there - sorry.

    Regards,
    D

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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