+ Reply to Thread
Results 1 to 7 of 7

VBA Highlight (select) all text within a combobox

  1. #1
    Forum Contributor
    Join Date
    05-24-2014
    MS-Off Ver
    Microsoft Office 2013
    Posts
    113

    VBA Highlight (select) all text within a combobox

    Hey guys. I have a combobox on a worksheet that every time a run a specific macro I would like it to highlight the text within the combobox. The reason I am doing this is to make it easier to input barcodes in that cell. Does anyone know how to do this?

  2. #2
    Forum Contributor pareshj's Avatar
    Join Date
    05-20-2014
    Location
    MUMBAI
    MS-Off Ver
    2007 & 2010
    Posts
    447

    Re: VBA Highlight (select) all text within a combobox

    Hi,

    To Highlight the text within combobox, you can use SetFocus.

    Please Login or Register  to view this content.

    Regards,
    Paresh J
    Click on "* Add Reputation" as a way to say thanks

  3. #3
    Forum Contributor
    Join Date
    05-24-2014
    MS-Off Ver
    Microsoft Office 2013
    Posts
    113

    Re: VBA Highlight (select) all text within a combobox

    Sorry. Couldn't get it to work...

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: VBA Highlight (select) all text within a combobox

    how did you make the combo box?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  5. #5
    Forum Contributor pareshj's Avatar
    Join Date
    05-20-2014
    Location
    MUMBAI
    MS-Off Ver
    2007 & 2010
    Posts
    447

    Re: VBA Highlight (select) all text within a combobox

    Hi,

    Please attached the excel file with issues.

    Regards,
    Paresh J

  6. #6
    Forum Contributor
    Join Date
    05-24-2014
    MS-Off Ver
    Microsoft Office 2013
    Posts
    113

    Re: VBA Highlight (select) all text within a combobox

    The combobox is an activex control within a sheet. It isn't within a combobox.

  7. #7
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: VBA Highlight (select) all text within a combobox

    maybe
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Highlight empty Combobox
    By crombie1984 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2013, 11:00 AM
  2. [SOLVED] Excel Userform: Populate other controls (i.e. textbox & combobox) based on combobox select
    By MileHigh_PhD in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-22-2013, 04:50 PM
  3. UserForm ComboBox Text Highlight Removal
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-13-2011, 12:53 PM
  4. VBA to find and select text within text and highlight
    By Marrick13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2011, 08:05 PM
  5. [SOLVED] Select Text Files from Combobox
    By D.Parker in forum Excel General
    Replies: 4
    Last Post: 06-28-2005, 12:05 PM

Tags for this Thread

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