Hello all,

Using Design Mode in the Developer Tab, I created three Option Boxes and grouped them.
  • Each of them is linked to Cell A1.
  • if Option box 1 is selected, Cell A1 returns a value as 1.
  • if option Box 2 is selected, Cell A1 returns a value 2.
  • if Option Box 3 is selected, Cell A returns a value 3.

Doubt :
  • Is there any way I can change this value being populated in Cell A1. The properties tab only asks to link a cell and it doesn't support formulas
  • Example : I want Cell A1 to return 16 when Option Box 3 is selected . is that possible ?

This not being an ActiveX control Option Box, I am unable to play around with