Consulting

Results 1 to 4 of 4

Thread: Updating a set of checkboxes once a listbox changes

  1. #1
    VBAX Newbie
    Joined
    Nov 2013
    Posts
    4
    Location

    Updating a set of checkboxes once a listbox changes

    Afternoon,

    Basically as the title states, is it possible to update a set of checkboxes if it's "True" or "False" depending on a cell?

    I've attached the file, with a working form. The user can select a duty (listbox) + multiple days (check boxes) press' "Update" (commandbutton) and it will place a "1" in the correct place.

    Is it possible to update the checkboxes according to the duty selected ?

    MDS-Test.zip

    Thanks!

  2. #2
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    You have cross-posted to http://www.excelforum.com/excel-prog...x-changes.html

    See this site about cross-posting: http://www.excelguru.ca/node/7

    The good news is that you did post a distinct subject line. Unfortunately, more detail is needed. What is the "correct place"? Give some data input for the userform and what you expect the output to be. Obviously, the checkboxes can be used do what you want for input and/or output.

  3. #3
    VBAX Newbie
    Joined
    Nov 2013
    Posts
    4
    Location
    Apologies, I didn’t know both sites were linked.
    I’ve replied on the other thread. Hopefully i've explained it a bit better, I added an attachment also.


    Thank you

  4. #4
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    Why reply in the other forum's thread when this thread was where I responded?

    No, the sites are not linked. The link that I posted explained that people that help often help in more than one forum. It is not fair to the free helpers to help solve a problem when it was solved in another forum or waste time looking at another duplicate post. I typically look at posts with 0 responses. So, if you reply to your own post, some may be like me and assume that the problem was solved. Some forums ask that you mark a thread solved when solved but it is not done consistently. That link was meant to help you understand cross-posting issues.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •