IIf(frmForm.opt

[cmxulb]

Hello,

This code below works, but if I add "both" it doesn't work

.Cells(iRow, 3) = IIf(frmForm.optLarge.Value = True, "Large", "Small") This code works


.Cells(iRow, 3) = IIf(frmForm.optLarge.Value = True, "Large", "Small", "Both") if I add "both" does not work.

How can I make it work by

adding "Both"?

 

[cmxulb]

yesss Thank You
This worked. took Me out add it FrmForm
View attachment 36500

Yessss Thank You! This worked.

View attachment 36502

One last thing.
For validation, this is the code without "Both"
How can you make work with "Both"

'Validating Scale


If .optLarge.Value = False And .optSmall.Value = False Then

MsgBox "Please select scale.", vbOKOnly + vbInformation, "scale"
ValidatePrintDetails = False
Exit Function

End If

NVM. I just add it And .optboth.value = False
Thanks