View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Whois Clinton Whois Clinton is offline
external usenet poster
 
Posts: 38
Default Option Button Value Zero?

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