Updating a set of checkboxes once a listbox changes

[jsneak]

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 ?

10854

Thanks!

[Kenneth Hobs]

You have cross-posted to http://www.excelforum.com/excel-programming-vba-macros/969775-updating-a-set-of-checkbox-once-a-listbox-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.

[jsneak]

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

[Kenneth Hobs]

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.