View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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.