remove checkbox ticks from last use upon opening user form

[TheNewGuy]

first of all, I apologize for asking a question that I KNOW has been answered before but, I am having trouble applying the answers I have found to my situation. I am simply trying to write a macro or code that will set all the check box values to "False" each time I initiate the User form. So that the user form does not "carry over" check box values from the last time the User form was used.
Thanks in advance for any help.any help at all..........

--edit---This did the trick!
However I had to make sure I cleared the value from the cell that each control is associated with.(the controlsource in the user form properties.)

Thanks for all your help!

Please Login or Register  to view this content.

[davegugg]

Isn't it just

Please Login or Register  to view this content.

with checkbox = to whatever you named your checkbox?
I believe you put that in the initialize form event.

[TheNewGuy]

Yea! That is what I thought, but the problem is that when the check box is un-ticked ,The sub checkbox1_click automatically runs. So it works but it only removes the tick from one check box each time you open the form. So if you had 5 check box's ticked you would need to open and close it 5 times to remove all the ticks..... I tried deleting the offending subprograms but it made no difference. This is what I have tried so far

Please Login or Register  to view this content.

Please Login or Register  to view this content.

There has to be something simple that I am doing wrong...But I don't know what it is.
Thanks for your help.

[royUK]

The default should be false so initialising should clear them

This function will clear all controls

Please Login or Register  to view this content.

On the UserForm

Please Login or Register  to view this content.

[TheNewGuy]

Thanks for your help royUK. I really appreciate it. But, I am still unable to get your code to work. Where should I paste your function code? and do I need to make a new command button that is set to clear the form? I would like the form to initialize with all check box values=false. I can attach my work book if you think it will help. Thanks again for all your help.

[davegugg]

Is the default set to "false" on the properties of each check box? (like royUK mentioned?)

[TheNewGuy]

Do you mean the value? If so yes it is set to "False" for each of the chackbox's. Thanks again for the help! Much appreciated!

[TheNewGuy]

OK now I am getting confused! I thought I had it working, in fact I know I had it clearing the values upon initialization, but now it is working as before. It only clears one checkbox value each time you initiate the form. Can some one please help me figure out why this is happening. Does it matter where I save the sub program that I posted in my first post? I would appreciate any advice. Thanks for your time.

-edit- I have noticed if I run the user form from the vb editor and press F8 for each line of code it will work as it should but if I run the user form from the workbook it does not.

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[TheNewGuy]

Ok, Thank you. That is no problem.
However in the process of making a dummy file for you I deleted all sheets that were before or after this sheet containing the userform,.. and now the userform gets cleared correctly....? SO, there must be some conflicting code somewhere. But I don't know were it is. So I have attached a copy of both the example workbook, and the complete workbook. Hopefully you can figure out what I have done to this thing! Again,Thank you very much for all your help!
-note- the user form I am working on is the one labeled "round specimen processes" it is activated by clicking the graphic at the top left of page "processes and router set up".

[tabbott0829]

Deleted post because I broke Forum rule #2.

[HaHoBe]

Hi, tabbott0829,

Welcome to the Forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

And please: use code tags around code.

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Ciao,
Holger