+ Reply to Thread
Results 1 to 3 of 3

If checkbox is checked then show text from dropdown list

  1. 07-14-2023, 04:50 AM #1
    Aresm
    Aresm is offline
    Registered User
    Join Date
    07-14-2023
    Location
    Maldives
    MS-Off Ver
    Office Standard 2013
    Posts
    3

    Post If checkbox is checked then show text from dropdown list

    Hi, can anyone please solve this..
    Basically I want to show the option from the dropdownlist if a checkbox is ticked.
    In this case I have a checkbox to show if a person is vip or not.
    If VIP checkbox is ticked then it should show me the option to select the VIP code from the dropdownlist and when the code is selected, then it show show the code description below the code.

    I hope you all understood what i am asking for.
    I have attached the workbook with the instructions.

    Thanks.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-14-2023, 06:55 AM #2
    ORoos
    ORoos is offline
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2021
    Posts
    974

    Re: If checkbox is checked then show text from dropdown list

    Hi there,

    A dropdown list (Data validation) is either there or not.

    I used a ListBox in a UserForm as a solution.

    Your Tick-box had cell A43 set as the linked cell. So we use that to trigger for the UserForm to show.

    Let us know if that works for you.
    Attached Files Attached Files
    If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.
    Reply With QuoteRegister To Reply
  3. 07-14-2023, 07:54 AM #3
    Aresm
    Aresm is offline
    Registered User
    Join Date
    07-14-2023
    Location
    Maldives
    MS-Off Ver
    Office Standard 2013
    Posts
    3

    Re: If checkbox is checked then show text from dropdown list

    Hi, Thank you so much. Yeah This works.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy text to worksheet if checkbox not checked
    By Willow12 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 03-15-2021, 05:42 PM
  2. Highlight Text In Cell if Checkbox is Un-Checked
    By dmartin55 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2021, 06:09 PM
  3. How do I generate text for rows whos checkbox is not checked?
    By Wiigit in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-26-2018, 12:56 PM
  4. Default text to show in dropdown list
    By Data2link in forum Excel General
    Replies: 2
    Last Post: 02-13-2015, 02:28 PM
  5. [SOLVED] I need to show the text value of a cell base from the selected data on the dropdown list
    By ECYOJ in forum Excel General
    Replies: 2
    Last Post: 03-31-2014, 01:32 AM
  6. If adjacent checkbox checked then put in new list with macro
    By ratdogexcel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-21-2013, 03:04 AM
  7. [SOLVED] When checkbox is checked it does not copy to new sheet. Only if not checked using false
    By thelisa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2013, 07:59 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1