Do you use Forms Option buttons ?

In the properties set a linked cell
Check the value of the cell in your code




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Andreas" wrote in message ...
I have group box with five option buttons, let's say they are called 1,2,3,4
and 5. Then I also have a button named Print. I would like to give the user
the opportunity to choose one of the option buttons and then press Print so
the particular sheet/part of sheet named in the option button gets printed.
Does anyone know VBA code for how to do this?

Would appreciate it!!

Andreas