+ Reply to Thread
Results 1 to 5 of 5

How do i change a Label to be dependent on an OptionBox?

  1. #1
    Registered User
    Join Date
    09-19-2021
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    15

    How do i change a Label to be dependent on an OptionBox?

    hello, im trying to make a userform that when an item from the command button (cbname) is clicked, the labels will have captions that change accordingly.
    here is what my form looks like, im trying to change labels 26 to 32. cbname is the combobox name. when i run my code, other labels will be changed. how do i specify that i want labels 26-32 to be the ones that change?
    photo1632397634 (1).jpeg

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    04-15-2013
    Location
    Singapore, Melbourne
    MS-Off Ver
    Office 365
    Posts
    167

    Re: How do i change a Label to be dependent on an OptionBox?

    Is that what you want?

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Row row row your boat
    Gently down the stream

  3. #3
    Registered User
    Join Date
    09-19-2021
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    15

    Re: How do i change a Label to be dependent on an OptionBox?

    hello! thank you so much for your help but somehow the wrong labels are getting changed and im not sure where my error is.
    Attachment 748883

  4. #4
    Forum Contributor
    Join Date
    04-15-2013
    Location
    Singapore, Melbourne
    MS-Off Ver
    Office 365
    Posts
    167

    Re: How do i change a Label to be dependent on an OptionBox?

    Would you please upload your original workbook? Because I am not able to see the pattern of your label object names.

  5. #5
    Registered User
    Join Date
    09-19-2021
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    15

    Re: How do i change a Label to be dependent on an OptionBox?

    Hello, here is the file, its under the sheet called Sheet1, i dont think ive reached the needed level to have attachments yet if you dont mind!
    Thank you so much for your help! photo1632442071.jpeg

+ 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] How do i change a Label to be dependent on an OptionBox?
    By shuxin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-23-2021, 12:57 AM
  2. [SOLVED] How do I change combobox to be dependent on OptionBox
    By shuxin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-21-2021, 01:46 AM
  3. Dependent Dropdown list change to formula when parent cell change
    By yuvanesh11 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2019, 04:00 AM
  4. Userform label dependent from combobox
    By Rui Farinha in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-13-2017, 11:51 AM
  5. Change userform label height without changing label width
    By vamosj in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-16-2015, 01:08 PM
  6. Replies: 4
    Last Post: 11-19-2014, 10:13 PM
  7. optionbox checkbox
    By flow23 in forum Excel General
    Replies: 3
    Last Post: 11-24-2005, 09:10 AM

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