Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro to clear checkboxes
Sorry for the duplicate posting. Previous posting was answered but solution
does not work and have had no further replies. Is it possible to have a macro that can change all checkboxes that have been set to checked back to €˜unchecked? I need a macro that will clear all of the checks in €˜checkboxes (forms object) on a sheet. The checkboxes are just basic checkboxes beside peoples names and are manually selected (checked) when that person has paid. I would like to be able to reset all of the checkboxes back to unchecked with a macro button. I cant get the auto record macro function to select a forms object. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro to clear checkboxes
Guy,
How you trigger the macro to do this is up to you but this uses a commnd button on your form Private Sub CommandButton1_Click() Dim cCont As Control For Each cCont In Me.Controls If TypeName(cCont) = "CheckBox" Then cCont.Value = False End If Next cCont End Sub Mike "Guy" wrote: Sorry for the duplicate posting. Previous posting was answered but solution does not work and have had no further replies. Is it possible to have a macro that can change all checkboxes that have been set to checked back to €˜unchecked? I need a macro that will clear all of the checks in €˜checkboxes (forms object) on a sheet. The checkboxes are just basic checkboxes beside peoples names and are manually selected (checked) when that person has paid. I would like to be able to reset all of the checkboxes back to unchecked with a macro button. I cant get the auto record macro function to select a forms object. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro to clear checkboxes
Hi Mike,
I am just a novice at this and I can't seem to get this to work. I think I have figured out how to post the code to the command button I put on the sheet but just can't get it to work. I just copied and pasted your code to the command button screen. This is the first time I have tried to use a command button and I am probably just making a simple mistake. Can you help? Guy "Mike H" wrote: Guy, How you trigger the macro to do this is up to you but this uses a commnd button on your form Private Sub CommandButton1_Click() Dim cCont As Control For Each cCont In Me.Controls If TypeName(cCont) = "CheckBox" Then cCont.Value = False End If Next cCont End Sub Mike "Guy" wrote: Sorry for the duplicate posting. Previous posting was answered but solution does not work and have had no further replies. Is it possible to have a macro that can change all checkboxes that have been set to checked back to €˜unchecked? I need a macro that will clear all of the checks in €˜checkboxes (forms object) on a sheet. The checkboxes are just basic checkboxes beside peoples names and are manually selected (checked) when that person has paid. I would like to be able to reset all of the checkboxes back to unchecked with a macro button. I cant get the auto record macro function to select a forms object. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro to clear checkboxes
Guy,
I had assumed you checkboxes were on a userform, if they are on a sheet then put a button on your sheet (You may already have done this) and assign this code to it Dim ws As Worksheet Dim obj As OLEObject Set ws = ActiveSheet For Each obj In ws.OLEObjects If TypeName(obj.Object) = "CheckBox" Then obj.Object.Value = False End If Next obj Mike "Guy" wrote: Hi Mike, I am just a novice at this and I can't seem to get this to work. I think I have figured out how to post the code to the command button I put on the sheet but just can't get it to work. I just copied and pasted your code to the command button screen. This is the first time I have tried to use a command button and I am probably just making a simple mistake. Can you help? Guy "Mike H" wrote: Guy, How you trigger the macro to do this is up to you but this uses a commnd button on your form Private Sub CommandButton1_Click() Dim cCont As Control For Each cCont In Me.Controls If TypeName(cCont) = "CheckBox" Then cCont.Value = False End If Next cCont End Sub Mike "Guy" wrote: Sorry for the duplicate posting. Previous posting was answered but solution does not work and have had no further replies. Is it possible to have a macro that can change all checkboxes that have been set to checked back to €˜unchecked? I need a macro that will clear all of the checks in €˜checkboxes (forms object) on a sheet. The checkboxes are just basic checkboxes beside peoples names and are manually selected (checked) when that person has paid. I would like to be able to reset all of the checkboxes back to unchecked with a macro button. I cant get the auto record macro function to select a forms object. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro to clear checkboxes
If those are checkboxes from the Forms toolbar:
Activesheet.checkboxes.value = xloff Guy wrote: Sorry for the duplicate posting. Previous posting was answered but solution does not work and have had no further replies. Is it possible to have a macro that can change all checkboxes that have been set to checked back to €˜unchecked? I need a macro that will clear all of the checks in €˜checkboxes (forms object) on a sheet. The checkboxes are just basic checkboxes beside peoples names and are manually selected (checked) when that person has paid. I would like to be able to reset all of the checkboxes back to unchecked with a macro button. I cant get the auto record macro function to select a forms object. -- Dave Peterson |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro to clear checkboxes
Thanks to everyone,
Ya'll are great! Special thanks to Dave, that is the simplest code I have ever used and works great. Thanks, Guy "Dave Peterson" wrote: If those are checkboxes from the Forms toolbar: Activesheet.checkboxes.value = xloff Guy wrote: Sorry for the duplicate posting. Previous posting was answered but solution does not work and have had no further replies. Is it possible to have a macro that can change all checkboxes that have been set to checked back to €˜unchecked€„¢? I need a macro that will clear all of the checks in €˜checkboxes€„¢ (forms object) on a sheet. The checkboxes are just basic checkboxes beside peoples names and are manually selected (checked) when that person has paid. I would like to be able to reset all of the checkboxes back to unchecked with a macro button. I can€„¢t get the auto record macro function to select a forms object. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to clear checkboxes and protected cells | Excel Worksheet Functions | |||
clear cells macro | Excel Discussion (Misc queries) | |||
Clear Checkboxes | Excel Discussion (Misc queries) | |||
How do I delete checkboxes from rows I deleted in a macro? | Excel Discussion (Misc queries) | |||
Macro to make all checkboxes false and clear all comboxes | Excel Discussion (Misc queries) |