Counting selected option buttons in column?

My option buttons are grouped by row (one per cell) so only one of five can
be selected in each row. Now I need to know how many have been selected in
each of the five columns and totals stored in a cell. Will one of you VBA
gurus please help me count how many option buttons are selected in each
column? Also, if there is a better method other than the option button to
accomplish this, I'm all ears. I have been having the users put a number 1
in the column and then auto sum the 1's at the bottom, (quite easy), however,
users keep screwing up and having more than one "1" in a row so I'm need a
better method of control.
-JEFF-

Assuming option buttons from the control toolbox toolbar.
If you have the optionbuttons linked to cells, then just do a countif on the
cells for True.

--
Regards,
Tom Ogilvy

"-JEFF-" <[email protected]> wrote in message
news:[email protected]...
> My option buttons are grouped by row (one per cell) so only one of five
can
> be selected in each row. Now I need to know how many have been selected
in
> each of the five columns and totals stored in a cell. Will one of you VBA
> gurus please help me count how many option buttons are selected in each
> column? Also, if there is a better method other than the option button to
> accomplish this, I'm all ears. I have been having the users put a number
1
> in the column and then auto sum the 1's at the bottom, (quite easy),
however,
> users keep screwing up and having more than one "1" in a row so I'm need a
> better method of control.
> -JEFF-

That works except it places the word "True" or "False" inside the cell behind
the control. It's purely aesthetics, but is there a way to prevent this?
-JEFF-

"Tom Ogilvy" wrote:

> Assuming option buttons from the control toolbox toolbar.
> If you have the optionbuttons linked to cells, then just do a countif on the
> cells for True.
>
> --
> Regards,
> Tom Ogilvy
>
> "-JEFF-" <[email protected]> wrote in message
> news:[email protected]...
> > My option buttons are grouped by row (one per cell) so only one of five
> can
> > be selected in each row. Now I need to know how many have been selected
> in
> > each of the five columns and totals stored in a cell. Will one of you VBA
> > gurus please help me count how many option buttons are selected in each
> > column? Also, if there is a better method other than the option button to
> > accomplish this, I'm all ears. I have been having the users put a number
> 1
> > in the column and then auto sum the 1's at the bottom, (quite easy),
> however,
> > users keep screwing up and having more than one "1" in a row so I'm need a
> > better method of control.
> > -JEFF-
>
>
>

You could format the font of the cell to be the same color as the
background.

You cold make the option button opaque and have it cover the cell

--
Regards,
Tom Ogilvy

"-JEFF-" <[email protected]> wrote in message
news:[email protected]...
> That works except it places the word "True" or "False" inside the cell
behind
> the control. It's purely aesthetics, but is there a way to prevent this?
> -JEFF-
>
> "Tom Ogilvy" wrote:
>
> > Assuming option buttons from the control toolbox toolbar.
> > If you have the optionbuttons linked to cells, then just do a countif on
the
> > cells for True.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "-JEFF-" <[email protected]> wrote in message
> > news:[email protected]...
> > > My option buttons are grouped by row (one per cell) so only one of
five
> > can
> > > be selected in each row. Now I need to know how many have been
selected
> > in
> > > each of the five columns and totals stored in a cell. Will one of you
VBA
> > > gurus please help me count how many option buttons are selected in
each
> > > column? Also, if there is a better method other than the option
button to
> > > accomplish this, I'm all ears. I have been having the users put a
number
> > 1
> > > in the column and then auto sum the 1's at the bottom, (quite easy),
> > however,
> > > users keep screwing up and having more than one "1" in a row so I'm
need a
> > > better method of control.
> > > -JEFF-
> >
> >
> >

Can I control the properties of these option buttons that are "from the
control toolbox toolbar" using VBA code? When I recorded a macro and changed
properties of an option button, it did not show up in the macro code.
-JEFF-

"Tom Ogilvy" wrote:

> You could format the font of the cell to be the same color as the
> background.
>
> You cold make the option button opaque and have it cover the cell
>
> --
> Regards,
> Tom Ogilvy
>
> "-JEFF-" <[email protected]> wrote in message
> news:[email protected]...
> > That works except it places the word "True" or "False" inside the cell
> behind
> > the control. It's purely aesthetics, but is there a way to prevent this?
> > -JEFF-
> >
> > "Tom Ogilvy" wrote:
> >
> > > Assuming option buttons from the control toolbox toolbar.
> > > If you have the optionbuttons linked to cells, then just do a countif on
> the
> > > cells for True.
> > >
> > > --
> > > Regards,
> > > Tom Ogilvy
> > >
> > > "-JEFF-" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > My option buttons are grouped by row (one per cell) so only one of
> five
> > > can
> > > > be selected in each row. Now I need to know how many have been
> selected
> > > in
> > > > each of the five columns and totals stored in a cell. Will one of you
> VBA
> > > > gurus please help me count how many option buttons are selected in
> each
> > > > column? Also, if there is a better method other than the option
> button to
> > > > accomplish this, I'm all ears. I have been having the users put a
> number
> > > 1
> > > > in the column and then auto sum the 1's at the bottom, (quite easy),
> > > however,
> > > > users keep screwing up and having more than one "1" in a row so I'm
> need a
> > > > better method of control.
> > > > -JEFF-
> > >
> > >
> > >
>
>
>

Yes, but you can't record the changes.

sheet1.Textbox1.BackColor = rgb(255,0,0)

as an example.

--
Regards,
Tom Ogilvy


"-JEFF-" <[email protected]> wrote in message
news:[email protected]...
> Can I control the properties of these option buttons that are "from the
> control toolbox toolbar" using VBA code? When I recorded a macro and
changed
> properties of an option button, it did not show up in the macro code.
> -JEFF-
>
> "Tom Ogilvy" wrote:
>
> > You could format the font of the cell to be the same color as the
> > background.
> >
> > You cold make the option button opaque and have it cover the cell
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "-JEFF-" <[email protected]> wrote in message
> > news:[email protected]...
> > > That works except it places the word "True" or "False" inside the cell
> > behind
> > > the control. It's purely aesthetics, but is there a way to prevent
this?
> > > -JEFF-
> > >
> > > "Tom Ogilvy" wrote:
> > >
> > > > Assuming option buttons from the control toolbox toolbar.
> > > > If you have the optionbuttons linked to cells, then just do a
countif on
> > the
> > > > cells for True.
> > > >
> > > > --
> > > > Regards,
> > > > Tom Ogilvy
> > > >
> > > > "-JEFF-" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > My option buttons are grouped by row (one per cell) so only one of
> > five
> > > > can
> > > > > be selected in each row. Now I need to know how many have been
> > selected
> > > > in
> > > > > each of the five columns and totals stored in a cell. Will one of
you
> > VBA
> > > > > gurus please help me count how many option buttons are selected in
> > each
> > > > > column? Also, if there is a better method other than the option
> > button to
> > > > > accomplish this, I'm all ears. I have been having the users put a
> > number
> > > > 1
> > > > > in the column and then auto sum the 1's at the bottom, (quite
easy),
> > > > however,
> > > > > users keep screwing up and having more than one "1" in a row so
I'm
> > need a
> > > > > better method of control.
> > > > > -JEFF-
> > > >
> > > >
> > > >
> >
> >
> >