+ Reply to Thread
Results 1 to 4 of 4

UserForm ComboBox Text Highlight Removal

  1. #1
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    UserForm ComboBox Text Highlight Removal

    When I select an option from a ComboBox on a UserForm, the text in the ComboBox remains highlighted and I have to click in the ComboBox to remove the Text Highlight.

    Is there any way when making a selection from the ComboBox to have the selection NOT highlighted/selected.

    Many thanks for any help...
    Last edited by HangMan; 07-13-2011 at 12:53 PM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: UserForm ComboBox Text Highlight Removal

    Hello hangman,

    The highlight function is by design and can not be changed. However, you can make the highlight to disappear in code by having another object take the focus after the selection is made or by adding the code to the ComboBox Click event.
    Please Login or Register  to view this content.
    .

  3. #3
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: UserForm ComboBox Text Highlight Removal

    You could move the focus to a different control, assuming you have one. This will move it to the next control in the tab order.

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Re: UserForm ComboBox Text Highlight Removal

    Leith/David

    Perfect, both solutions work perfectly...

    Many thanks to you both. Gratefully appreciated.

+ 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