Reordering Option Box sequence Numbers

Originally Posted by Squeaky

Hi subbby,
What you can do is place a formula that will give the desired result in another cell, and have the following cells or formulas point to that one. =if(a1=3,16,a1) or tie them all to a different cell and place the formula in A1.

Thanks. Is there no other way? Like to renumber the Options Box Sequence? The active X Option Box would let us edit this numbering in its properties tab. The form control's Option Box's properties isn't very helpful

Thanks for the tip.

I guess you can make 16 Form Control option boxes, and use box 1, 2, and 16. You can then carefully place all of the unused boxes underneath the first box. Before you place box 1 at the top, make sure you
"bring it to the front" by right clicking the box and selecting "order...". I would also give it a white or colored background instead of leaving it transparent.
My first solution is far easier.