+ Reply to Thread
Results 1 to 3 of 3

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, i have a userform and i want it to have one set of labels (range a14:a20) show on the form when an option box (obmale) is clicked and another set of labels when obfem is clicked but im too sure where my mistake is. here is my code!

    Please Login or Register  to view this content.
    Attached Images Attached Images
    Last edited by shuxin; 09-23-2021 at 01:02 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    11-04-2018
    Location
    Denpasar
    MS-Off Ver
    Excel 2010
    Posts
    777

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

    Please Login or Register  to view this content.
    one set of labels (range a14:a20) show on the form when an option box (obmale) is clicked and another set of labels when obfem is clicked
    So, the code above has nothing to do with the ComboBox.
    It runs only when any of the two OptBut is clicked.
    Last edited by karmapala; 09-22-2021 at 11:45 PM.

  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?

    omg it works, thank you so much for this!

+ 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 combobox to be dependent on OptionBox
    By shuxin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-21-2021, 01:46 AM
  2. 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
  3. Userform label dependent from combobox
    By Rui Farinha in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-13-2017, 11:51 AM
  4. 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
  5. Code VBA checkbox and optionbox
    By hitmen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2014, 02:02 PM
  6. optionbox checkbox
    By flow23 in forum Excel General
    Replies: 3
    Last Post: 11-24-2005, 09:10 AM
  7. OptionBox error checking
    By Patrick Simonds in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2005, 03:39 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