+ Reply to Thread
Results 1 to 4 of 4

Listbox option dependent on which checkbox is checked

  1. #1
    Forum Contributor
    Join Date
    07-08-2015
    Location
    Indiana
    MS-Off Ver
    Excel 2007
    Posts
    128

    Listbox option dependent on which checkbox is checked

    Hello experts. I searched but couldnt find anything that helped me.
    I am designing a user form with 16 checkboxes. Dependent on which set of 4 check boxes (1-4; 5-8; 9-12, 13-16--- yes they need to be seperatly labeled but are similar in listbox options), I need a different set of options in the listbox.

    I am wondering if its a simple

    Please Login or Register  to view this content.
    etc......

    Is this correct?
    Where will this go so that when the cb is checked, the list option will appear in the list box.

    Thanks in advance

  2. #2
    Forum Contributor kalbasiatka's Avatar
    Join Date
    02-27-2016
    Location
    Brest, Belarus
    MS-Off Ver
    2021
    Posts
    224

    Re: Listbox option dependent on which checkbox is checked

    Hi. And what hinders to try your code in action?
    "if cb1" the same as "if cb1 = True"
    For what the brackets in the third line?
    To do it for me and help me it is 2 different things!
    Sorry for my english, blame Google translator

  3. #3
    Forum Contributor
    Join Date
    07-08-2015
    Location
    Indiana
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Listbox option dependent on which checkbox is checked

    I did try it and it wasn't populating the listbox. Thats why i was asking if more was needed and where in the coding it needed to go.

    As for the brackets, chalk it up to laziness when I posted it.

  4. #4
    Forum Contributor kalbasiatka's Avatar
    Join Date
    02-27-2016
    Location
    Brest, Belarus
    MS-Off Ver
    2021
    Posts
    224

    Re: Listbox option dependent on which checkbox is checked

    did not understand but I'll try to guess
    Attached Files Attached Files

+ 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] 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
  2. [SOLVED] Check if any option in listbox checked
    By Alexander_Golinsky in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-12-2013, 01:15 PM
  3. [SOLVED] VBA code to uncheck checkbox 2 & 3 if checkbox 1 is checked
    By hydz1213 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-25-2013, 03:10 AM
  4. Transferring checked checkbox to another row
    By src16 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-30-2013, 02:52 PM
  5. VB checkbox checked?
    By prowsdower in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-13-2009, 12:05 PM
  6. How to have Checkbox A uncheck with checked Checkbox B
    By Texas Aggie 09 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2007, 09:29 AM
  7. Is checkbox is checked?
    By Fred S in forum Excel General
    Replies: 2
    Last Post: 10-18-2005, 11:05 PM
  8. If Checkbox checked/notchecked then
    By Darrin Henry in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2005, 02:06 PM

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