btw, if you want, here's that counting checkboxes code. sounds like
you don't need it, but i'm throwing it in anyway just in case (& for
future searchers who might run across this post).
:)
======================
Option Explicit

Private Sub CommandButton1_Click()

Dim wks As Worksheet
Dim oleobj As OLEObject
Dim mynumber As Integer

Set wks = ActiveSheet
mynumber = 0

For Each oleobj In wks.OLEObject
If TypeOf oleobj.Object Is msforms.CheckBox Then
If oleobj.Object.Value = True Then
mynumber = mynumber + 1
End If
End If
Next oleobj

MsgBox "the number of checked boxes is " & mynumber

End Sub
=========================
susan


On Dec 24, 4:48*pm, Bupkus wrote:
mama, you hit it on the nail head.
Thanks



"Teethless mama" wrote:
select your data range (eg. A1:A10)

Data Validation Allow: select Custom Formula: =A1="x" * OK out

"Bupkus" wrote:

Correction: Validation against anything except "x" is what I meant.

"Bupkus" wrote:

That's great, thanks.
However, how can I restrict the user from accidently entering a space char
or any other char while I'm asking. I would like a Verification warning
atleast.
BTW, no row totals in right most column is needed.
Thanks again.

"Susan" wrote:

just put an "x" in each activity column/row.
at the bottom of each column (or at the end of each row, if you'd
rather) have a counta formula:

=counta(a2:a25)

that will give you the # of x's in each row.
OH WAIT, that won't work. *because it will also count the wording
you've got there for either name or activity........

try this instead:

=countif(a2:d2,"x") * this is for rows
=countif(a2:a25,"x") * this is for columns

now it will only count the x's.
hope it helps (or at least gets you started!)
:)
susan

On Dec 24, 3:52 pm, Bupkus wrote:
I have a table of 25 columns and a variable number of rows. Each row
represents a person and each column represents an activity. If person has
requested an activity then user mouse clicks in cell to mark person to that
activity. Bottom row has totals for each activity.
I would like a checkbox matrix where cells with checked box are counted in
the Totals row.
I'm over my head here and time doesn't allow for me any more research.
Thanks.- Hide quoted text -

- Show quoted text -