Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear a Checkbox in a a user form
I am new to creating user forms so forgive me if this is really basic. I
have a checkbox that when clicked opens a new user form to get more details for this product. I am trying to make it so if the user picks the "Cancel" command it unloads the detail page and also clears the checkbox on the original user form. How do I go about this? Thanks for any help on this in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear a Checkbox in a a user form
hi
check boxes are boolean. in the code that unloads the detail page, add this.. if checkbox1= true then checkbox1 = false end if this will clear the check from the box. Regards FSt1 "Cerberus" wrote: I am new to creating user forms so forgive me if this is really basic. I have a checkbox that when clicked opens a new user form to get more details for this product. I am trying to make it so if the user picks the "Cancel" command it unloads the detail page and also clears the checkbox on the original user form. How do I go about this? Thanks for any help on this in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear a Checkbox in a a user form
I tried that code but I may have done something wrong. I put this in
Private Sub CommandNOKEXT_Click() If CheckExtension = True Then CheckExtension = False End If Unload Extensions End Sub and I also tried it withe the Unload Extensions first but I still have the checkbox marked. "FSt1" wrote: hi check boxes are boolean. in the code that unloads the detail page, add this.. if checkbox1= true then checkbox1 = false end if this will clear the check from the box. Regards FSt1 "Cerberus" wrote: I am new to creating user forms so forgive me if this is really basic. I have a checkbox that when clicked opens a new user form to get more details for this product. I am trying to make it so if the user picks the "Cancel" command it unloads the detail page and also clears the checkbox on the original user form. How do I go about this? Thanks for any help on this in advance. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear a Checkbox in a a user form
Make sure you refer to the right CheckExtension checkbox. Qualify it by the
userform name: Private Sub CommandNOKEXT_Click() 'just uncheck it userform1.CheckExtension = False Unload Me 'Extensions 'show the original userform???? userform1.show '???? End Sub Cerberus wrote: I tried that code but I may have done something wrong. I put this in Private Sub CommandNOKEXT_Click() If CheckExtension = True Then CheckExtension = False End If Unload Extensions End Sub and I also tried it withe the Unload Extensions first but I still have the checkbox marked. "FSt1" wrote: hi check boxes are boolean. in the code that unloads the detail page, add this.. if checkbox1= true then checkbox1 = false end if this will clear the check from the box. Regards FSt1 "Cerberus" wrote: I am new to creating user forms so forgive me if this is really basic. I have a checkbox that when clicked opens a new user form to get more details for this product. I am trying to make it so if the user picks the "Cancel" command it unloads the detail page and also clears the checkbox on the original user form. How do I go about this? Thanks for any help on this in advance. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear a Checkbox in a a user form
hi
did you reference the other form???? Private Sub CommandNOKEXT_Click() If Userform1.CheckExtension = True Then Userform1.CheckExtension = False End If Unload Extensions End Sub otherwise the code may think your talking about the current userform. maybe i didn't make that clear. Regards FSt1 "Cerberus" wrote: I tried that code but I may have done something wrong. I put this in Private Sub CommandNOKEXT_Click() If CheckExtension = True Then CheckExtension = False End If Unload Extensions End Sub and I also tried it withe the Unload Extensions first but I still have the checkbox marked. "FSt1" wrote: hi check boxes are boolean. in the code that unloads the detail page, add this.. if checkbox1= true then checkbox1 = false end if this will clear the check from the box. Regards FSt1 "Cerberus" wrote: I am new to creating user forms so forgive me if this is really basic. I have a checkbox that when clicked opens a new user form to get more details for this product. I am trying to make it so if the user picks the "Cancel" command it unloads the detail page and also clears the checkbox on the original user form. How do I go about this? Thanks for any help on this in advance. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear a Checkbox in a a user form
If I wasn't so new at it and/or I wasn't a little slow on the up-take, you
were clear. Thanks for your help. "FSt1" wrote: hi did you reference the other form???? Private Sub CommandNOKEXT_Click() If Userform1.CheckExtension = True Then Userform1.CheckExtension = False End If Unload Extensions End Sub otherwise the code may think your talking about the current userform. maybe i didn't make that clear. Regards FSt1 "Cerberus" wrote: I tried that code but I may have done something wrong. I put this in Private Sub CommandNOKEXT_Click() If CheckExtension = True Then CheckExtension = False End If Unload Extensions End Sub and I also tried it withe the Unload Extensions first but I still have the checkbox marked. "FSt1" wrote: hi check boxes are boolean. in the code that unloads the detail page, add this.. if checkbox1= true then checkbox1 = false end if this will clear the check from the box. Regards FSt1 "Cerberus" wrote: I am new to creating user forms so forgive me if this is really basic. I have a checkbox that when clicked opens a new user form to get more details for this product. I am trying to make it so if the user picks the "Cancel" command it unloads the detail page and also clears the checkbox on the original user form. How do I go about this? Thanks for any help on this in advance. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clear a Checkbox in a a user form
glad i could help.
regards FSt1 "Cerberus" wrote: If I wasn't so new at it and/or I wasn't a little slow on the up-take, you were clear. Thanks for your help. "FSt1" wrote: hi did you reference the other form???? Private Sub CommandNOKEXT_Click() If Userform1.CheckExtension = True Then Userform1.CheckExtension = False End If Unload Extensions End Sub otherwise the code may think your talking about the current userform. maybe i didn't make that clear. Regards FSt1 "Cerberus" wrote: I tried that code but I may have done something wrong. I put this in Private Sub CommandNOKEXT_Click() If CheckExtension = True Then CheckExtension = False End If Unload Extensions End Sub and I also tried it withe the Unload Extensions first but I still have the checkbox marked. "FSt1" wrote: hi check boxes are boolean. in the code that unloads the detail page, add this.. if checkbox1= true then checkbox1 = false end if this will clear the check from the box. Regards FSt1 "Cerberus" wrote: I am new to creating user forms so forgive me if this is really basic. I have a checkbox that when clicked opens a new user form to get more details for this product. I am trying to make it so if the user picks the "Cancel" command it unloads the detail page and also clears the checkbox on the original user form. How do I go about this? Thanks for any help on this in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
clear specific cells in a form | Excel Discussion (Misc queries) | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
Form CheckBox font size / style | Excel Discussion (Misc queries) | |||
How do I make a checkbox bigger in an excel form? | Excel Discussion (Misc queries) | |||
Button to clear user worksheet | Excel Discussion (Misc queries) |