OptionButton problem

P

Paul

I have 3 option button in a group name 'BizType'
I need to add the name of the button selected to my
worksheet

Worksheets("EnqHead").Cells(2, "A") = Selected option
button

Any ideas appreciated.

Thank you.

Paul
 
B

Bob Phillips

Paul,

You will need to tie some code to the buttons, and then load the cell from
that, something like

Sub OptionButton2_Click()
Range("H1").Value = Application.Caller
End Sub


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top