+ Reply to Thread
Results 1 to 3 of 3

Update label caption upon selecting Listbox item

  1. #1
    Registered User
    Join Date
    05-11-2007
    Posts
    22

    Update label caption upon selecting Listbox item

    I'm not sure if there's a way to do this, but is it possible to be able to update a label's caption on a UserForm upon selecting an item in a listbox? For example:

    1. I select a date (item) from the Listbox

    2. The caption of the label automatically updates to a value (ex. 98%)

    3. If I select a different date, upon clicking on the item, it will update to a different value.

    Is there any possible way to do this? If not, I guess I gotta try a different method. Any feedback or help would be GREATLY appreciated. Thanks guys.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    Sound like you need a macro linked to the ListBox1_Change event (assuming your list box is called ListBox1.)
    Martin

  3. #3
    Registered User
    Join Date
    05-11-2007
    Posts
    22

    Awesome

    You've just gave me the perfect idea to get around to it, and I managed to find a solution by throwing some code into the ListBox_Click macro. Thanks a lot for your feedback!

+ 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