@Anonymous
For tasks like this Switch() function is best.
ComboBox1.Selected.Value
Options:
op1
op2
op3
op4
op5
Actions :
op1 = "Smile"
op2 = "Clap"
op3 = "Happy"
op4= "Sad"
op5 = "Good"
Code :
Switch(
ComboBox.Selected.Value,
"op1",
"Smile",
"op2",
"Clap",
"op3",
"happy",
"op4",
"Sad",
"op5",
"Good"
)
Switch( Formula / Control, Match1, Result1 [, Match2, Result2, ... [, DefaultResult ] ] )