+ Reply to Thread
Results 1 to 9 of 9

Change Userform Label based on ComboBox Selection

  1. #1
    Registered User
    Join Date
    04-04-2009
    Location
    Nashville, TN,USA
    MS-Off Ver
    Excel 2007
    Posts
    87

    Change Userform Label based on ComboBox Selection

    Hello,

    I have a userform that has a "payment type" combo box

    This box consists of:
    Please Login or Register  to view this content.
    I want a label to change based on what was selected from the combobox.

    EX.

    If Check is selected
    I want the label to say "check number"


    Thanks for all of the help in the past, present, and the future!!

    I love this Forum!!!
    Last edited by rbyrd023; 12-21-2009 at 05:37 PM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Change Userform Label based on ComboBox Selection

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    04-04-2009
    Location
    Nashville, TN,USA
    MS-Off Ver
    Excel 2007
    Posts
    87

    Re: Change Userform Label based on ComboBox Selection

    Sorry, I edited the original!

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Change Userform Label based on ComboBox Selection

    Thanks for taking the time to read and comply with the rule .

  5. #5
    Registered User
    Join Date
    04-04-2009
    Location
    Nashville, TN,USA
    MS-Off Ver
    Excel 2007
    Posts
    87

    Re: Change Userform Label based on ComboBox Selection

    Thank you for taking the time to show me. Do you have any suggestions for my problem?
    Last edited by rbyrd023; 12-21-2009 at 05:37 PM.

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Change Userform Label based on ComboBox Selection

    TRy something like this
    Please Login or Register  to view this content.
    Note the listindex starts at zero, so the first selection will be 0

  7. #7
    Registered User
    Join Date
    04-04-2009
    Location
    Nashville, TN,USA
    MS-Off Ver
    Excel 2007
    Posts
    87

    Re: Change Userform Label based on ComboBox Selection

    WORKS PERFECT!!!! Thank you for your help!!!!!

  8. #8
    Registered User
    Join Date
    12-02-2013
    Location
    uk
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Change Userform Label based on ComboBox Selection

    Hi,
    What code would need to be used if i would like the label's caption to return its value based on a cell?

    For example, if my dropdown menu was populated with 'Unique IDs', if for example ID12 was selected, could the label's caption then be the date that is in a cell next to the unique id?

    Thanks for reading my question.

  9. #9
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Change Userform Label based on ComboBox Selection

    Hello thirdbrad,
    welcome! please open your own thread!
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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