Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting selected option buttons in column?
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-" wrote in message ... 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- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting selected option buttons in column?
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-" wrote in message ... 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- |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting selected option buttons in column?
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-" wrote in message ... 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-" wrote in message ... 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- |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting selected option buttons in column?
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-" wrote in message ... 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-" wrote in message ... 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- |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting selected option buttons in column?
Yes, but you can't record the changes.
sheet1.Textbox1.BackColor = rgb(255,0,0) as an example. -- Regards, Tom Ogilvy "-JEFF-" wrote in message ... 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-" wrote in message ... 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-" wrote in message ... 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- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option Buttons/Radio Buttons | New Users to Excel | |||
Forms Option Buttons(Can be right mouse selected when sheet is loc | Excel Discussion (Misc queries) | |||
Navigating between option buttons is not selecting the option | Excel Programming | |||
Navigating between option buttons is not selecting the option | Excel Programming | |||
Option Buttons | Excel Programming |