Hi,

I have several groups of of Option Buttons from the "Forms" toolbar on a
worksheet. Currently each group is linked to a cell and reports a numeric
value (1-5) in that cell. The values denote a scale which I want the values
to rank 0-4 instead of 1-5. Is there a way to make this change in output so
that the number results come out 0-4 instead of 1-5.

TIA,
Clint

You can't change the value in the linked cell. Whatever formula or
code uses that value must do the conversion.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Wed, 3 Dec 2008 11:16:33 -0800, Whois Clinton
wrote:

Hi,

I have several groups of of Option Buttons from the "Forms" toolbar on a
worksheet. Currently each group is linked to a cell and reports a numeric
value (1-5) in that cell. The values denote a scale which I want the values
to rank 0-4 instead of 1-5. Is there a way to make this change in output so
that the number results come out 0-4 instead of 1-5.

TIA,
Clint

Option buttons have a maximum of three values, 0, 1 or Null, eqiovalent to
off, on or null, Yes, No or null. How are you getting values of 1 - 5? If
you are referring to the index numbers assigned by VBA, you would probably
have to use an array of zero base to get the 0 - 4 and use the array rather
than the button collection.

"Whois Clinton" wrote:

Hi,

I have several groups of of Option Buttons from the "Forms" toolbar on a
worksheet. Currently each group is linked to a cell and reports a numeric
value (1-5) in that cell. The values denote a scale which I want the values
to rank 0-4 instead of 1-5. Is there a way to make this change in output so
that the number results come out 0-4 instead of 1-5.

TIA,
Clint

Thanks,
I guess I am rweferring to the index. I have tyhe group assigned to a cell
where it gives a result 1-5 depending on which button is chosen. Does this
still mean I have to use arrays etc.? If so how do I do that?

"JLGWhiz" wrote:

Option buttons have a maximum of three values, 0, 1 or Null, eqiovalent to
off, on or null, Yes, No or null. How are you getting values of 1 - 5? If
you are referring to the index numbers assigned by VBA, you would probably
have to use an array of zero base to get the 0 - 4 and use the array rather
than the button collection.

"Whois Clinton" wrote:

Hi,

I have several groups of of Option Buttons from the "Forms" toolbar on a
worksheet. Currently each group is linked to a cell and reports a numeric
value (1-5) in that cell. The values denote a scale which I want the values
to rank 0-4 instead of 1-5. Is there a way to make this change in output so
that the number results come out 0-4 instead of 1-5.

TIA,
Clint

I would just use a helper cell and subtract 1 from the linked cell.



Whois Clinton wrote:

Hi,

I have several groups of of Option Buttons from the "Forms" toolbar on a
worksheet. Currently each group is linked to a cell and reports a numeric
value (1-5) in that cell. The values denote a scale which I want the values
to rank 0-4 instead of 1-5. Is there a way to make this change in output so
that the number results come out 0-4 instead of 1-5.

TIA,
Clint

--

Dave Peterson

WOW Cell value minus one, s olution for excel that is so simple I couldn't
even imagine it in all my possibilites. Lol. Thanks for the clear thinking.
Clint

"Dave Peterson" wrote:

I would just use a helper cell and subtract 1 from the linked cell.



Whois Clinton wrote:

Hi,

I have several groups of of Option Buttons from the "Forms" toolbar on a
worksheet. Currently each group is linked to a cell and reports a numeric
value (1-5) in that cell. The values denote a scale which I want the values
to rank 0-4 instead of 1-5. Is there a way to make this change in output so
that the number results come out 0-4 instead of 1-5.

TIA,
Clint

--

Dave Peterson