Solved: User form problem

[blackie42]

I have set up a form with a combo box and 3 option buttons

depending on whats selected from combo & which optionbutton is selected it goes off and executes that bit of the code.

Tryna get it so if combo is selected but no optionbutton then it goes no further (well puts out a message 'select tier') but it seems to skip and go to the end of the code where there is a message that input was succesful.

think I might have the syntax wrong?

If Form.cmb = "" Then
MsgBox "Select Portfolio"
Exit Sub
End If

If Form.OptT1 = "" And Form.OptT2 = "" And Form.OptT3 = "" Then
MsgBox "select tier"
Exit Sub
End If

any ideas what I'm missing?

thanks

[unmarkedhelicopter]

What does "Tryna" mean ???

If not (Form.OptT1 or Form.OptT2 or Form.OptT3) Then
MsgBox "select tier"
Exit Sub
End If

[blackie42]

thank - works fine - tryna s'pose its nothern UK slang for trying to.

thanks again

[unmarkedhelicopter]

Just a tip, if you are posting on an international forum, then try to use standard international English so more people will understand you.

[lucas]

why not show your flags guys?

[unmarkedhelicopter]

Why ?

[Bob Phillips]

Why not?

[unmarkedhelicopter]

So I can pose as a Chilean ?

[Bob Phillips]

You can even pose as English if you want.

[unmarkedhelicopter]

S?, usted tiene raz?n, yo no hab?a pensado en esto