Clearing Tick and Radio Buttons?

[KarenV]

Morning, something very easy for all your experts out there I'm sure , but how do clear tick boxes and radio buttons back to unchecked? I am using a Macro to clear the form but can't reset the those two buttons back to unchecked? I appreciate your help.
cheers

[Sean Thomas]

Please Login or Register  to view this content.

[KarenV]

Thanks Sean, I added that code to my Macro (which is in a template), but when I ran it, it doesn't clear the boxes? What am I doing wrong?

[Leith Ross]

Hello KarenV
,

There are two types of controls: Forms and ActiveX. The code Sean posted is for an ActiveX control. Just because it did not work does not mean your controls are Forms controls. Clearing ActiveX controls on worksheet is a bit more involved. To get a correct and fast response you should post a copy of your workbook.

To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

File Manger Pic

[KarenV]

Thanks for your help, I have attached a copy of the file.

[Sean Thomas]

Hi, you are using form controls.
If you want to control them/reset them using vba you will need to use activeX controls.

[Leith Ross]

Hello KarenV,

The macro below has been added to the attached workbook. This will clear the form completely except for cells with formulas and reset the controls.

Please Login or Register  to view this content.

[KarenV]

Hi Leith

That is perfect thank you - I feel so incompetent sometimes. In the original macro, I had it copying the range 'output' and placing it in the range 'database' so that it recorded and saved everything being entered - but now that doesn't work, yet it is still there in the macro, and when it cleared the form, it entered the current date automatically and that doesn't work either, yet is still there too. I know I am no expert, but it is so frustrating - hope you can help me.
thanks