OptionButton problem

  • Thread starter Thread starter Paul
  • Start date Start date
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
 
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)
 
Back
Top