View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BZeyger BZeyger is offline
external usenet poster
 
Posts: 31
Default Select All button

I currently have a VBA app that has users select which records they would
like to process. When the information populates in the form, they would have
to manualy check off all the desired records.

How can I have a button automatically but a check box in the of the records.
The form get processed if the Run option is selected in the record.

Form Name: Main_form
Subform Name: info_subform
data field: run (it is a YES/NO type)
field name: chkrun

I would like the button cmdCheckAll to place a check in all the records. The
same would work for uncheck.