+ Reply to Thread
Results 1 to 3 of 3

Modify Userform to highlight or unhighlight displayed ComboBox Value

  1. #1
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    263

    Modify Userform to highlight or unhighlight displayed ComboBox Value

    I currently have a worksheet with two columns in it: Column A has file name and Column B has file path and name. These two columns are part of a named ranged called "Files", which I use as a "RowSource" for a ComboBox in a userform that displays these images in the userform.

    What I am trying to do is use to command buttons that will either "highlight" or "unhighlight" the file name (column A) that is actively displayed in the ComboBox should the appropriate command button be activated (basically, perform a fill of yellow color if the "highlight" box is activated and remove all fills if unhighlight is activated). Any ideas how I would do so...

    Attached is the workbook...the two command buttons do not have VBA assigned to them..Thx..

    Book2.xlsm

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Modify Userform to highlight or unhighlight displayed ComboBox Value

    If you only want to act on the selected file names, one button will suffice. It will hightlight or unhighlight the cell of the selected filename.

    Please Login or Register  to view this content.
    You should check the attached file, my Mac probably messed up the RowSource.
    Attached Files Attached Files
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    263

    Re: Modify Userform to highlight or unhighlight displayed ComboBox Value

    Excellent.. I like the fact you were able to get it done with one button instead of two..Thanks.

+ 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. [SOLVED] VBA code to highlight and unhighlight cells as you click in a worksheet
    By chrispy67 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2014, 07:43 PM
  2. [SOLVED] Highlight and unhighlight cells
    By Jay-1.1 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 03-28-2013, 05:11 PM
  3. Replies: 1
    Last Post: 06-22-2012, 11:37 PM
  4. Modify worksheet whith userform displayed
    By thestappa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-04-2009, 01:26 PM
  5. [SOLVED] highlight/unhighlight (or color/uncolor) cells containing a specific character
    By markx in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-13-2005, 11:05 AM

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