PDA

View Full Version : Option choices - how do I export results?



Sir Babydum GBE
09-06-2007, 10:30 AM
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
09-06-2007, 10:36 AM
Hi, ...how to I get the result in one cell - say A1 for the sake of argument.

No worries - got it.


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

I'm learning...