+ Reply to Thread
Results 1 to 3 of 3

How can I change the appearance of ListBox.Text after it has been selected.

  1. #1
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    How can I change the appearance of ListBox.Text after it has been selected.

    I have a listbox whose list is populated by a dynamic range.
    Each element will be selected two times. After the first time I would like the colour of the text to be changed from Black to Red and after the second time I would like the red Text to be struck through.
    It is easy to do this to the source range, but unfortunately the Listbox still shows the black type. Can it be forced to mirror the attributes of the text in the source range?
    I have attached a workbook to show where i start from. The two buttons are used to make the two different kinds of selection.
    Help would be gratefully received.
    John
    Attached Files Attached Files

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: How can I change the appearance of ListBox.Text after it has been selected.

    Quote Originally Posted by j_Southern View Post
    Can it be forced to mirror the attributes of the text in the source range?
    No, unfortunately. Best you could hope for is to remove it and pass it to an additional listbox.
    David
    (*) Reputation points appreciated.

  3. #3
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Re: How can I change the appearance of ListBox.Text after it has been selected.

    David,
    Thanks for your reply. It's a bid sad, but I can stop searching now and get on with my life!
    John

+ 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