Re: all the check boxes should be checked if i check a particular checkbox in that row

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

With ActiveSheet
.CheckBoxes("A").Value = .CheckBoxes("All").Value
.CheckBoxes("B").Value = .CheckBoxes("All").Value
'etc.
End With



--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

<rg.ruchigoel@xxxxxxxxx> wrote in message
news:1176875314.248687.46730@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi

I have created 9 checkboxes in a particular sheet in a single row,
each in a single cell.
first checkbox is named 'All' and other 8 are named 'A' to 'H'. I want
when I will check 'All' checkbox all the other 8 checkboxes should
also be checked and similarly when i uncheck 'All' others should also
be unchecked. But the other 8 checkboxes can be individually checked
or unchecked. Actually these checkboxes are created to display some
data. I have done coding in Macro to display all the data when 'All'
is checked and to display individual data when other 8 checkboxes 'A'
to 'H' are checked or unchecked but in the sheet I want on checking
'All' checkbox other 8 checkboxes should also be checked bydefault.
So suggest me how can I this.



.

Relevant Pages

  • Re: calendar question?
    ... The second method is to run an update query to uncheck the boxes. ... the checkboxes from the table ... must be reset when the task is completed and checked. ... UPDATE MyTable SET FieldName = False WHERE FieldName = True AND ...
    (microsoft.public.access.formscoding)
  • checkboxes and update query
    ... I have a form/table with checkboxes that I would like the user to ... check / uncheck if they want a certain record to display in a gallery ... echo ''. ...
    (comp.lang.php)
  • Re: IIS website not authenticating anonymous
    ... you have to make sure that all of the checkboxes on the bottom ... of the same window are ... With IIS5, I think the "Integrated" checkbox is checked by ... default and you have to UNcheck it purposefully. ...
    (microsoft.public.inetserver.iis)
  • Re: Checkboxes and Protected Document
    ... hundered checkboxes throughout the document. ... When all the editing is done, the user runs the single macro for the ... http://www.gmayor.com/Macrobutton.htm to check and uncheck the box and run ... I've noticed that when I protect the document (View / Forms / ...
    (microsoft.public.word.docmanagement)
  • Re: all the check boxes should be checked if i check a particular checkbox in that row
    ... For Each chkbx In ActiveSheet.OLEObjects ... I have created 9 checkboxes in a particular sheet in a single row, ... also be checked and similarly when i uncheck 'All' others should also ... I have done coding in Macro to display all the data when 'All' ...
    (microsoft.public.excel.programming)