Option choices - how do I export results?

[Sir Babydum GBE]

Hi

On my userform I have some option buttons, the user selects them to say "yes", "no", or "n/a" - but I want the result to go to one cell when the user submits the record.

I also have a similar situation has two comboboxes to select from. the input from one cancels the other out - so again, how to I get the result in one cell - say A1 for the sake of argument.

Thanks

[Sir Babydum GBE]

Hi, ...how to I get the result in one cell - say A1 for the sake of argument.

No worries - got it.


[vba]If opt1 = True Then
ActiveCell.Value = "yes"
ElseIf opt2 = True Then
ActiveCell.Value = "no"
Else
ActiveCell.Value = "n/a"
End If[/vba]

I'm learning...