View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ekreider ekreider is offline
external usenet poster
 
Posts: 9
Default Check for "CheckBox"

I have a Uerform that has "CheckBoxes" and I would like to check and see
which is true so I can enter some data into a cell. The check boxes are
listed as SunCheckbox, MonCheckBox, and so on. The example I am sending is
just a simple example and the letter "n" is to repersent the check box name.

Example:
For c = 1 to 7
n = Format(c, "ddd") & "CheckBox"
If n = True Then Activecell.Offset(0, c+1) = 1
Next c

I hope you can understand what I am trying to do.

Thanks,

ek