OptionButton problem
 

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

OptionButton problem
 

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)

"Paul" wrote in message
...
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