PDA

View Full Version : Solved: User form problem



blackie42
10-17-2007, 05:20 AM
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
10-17-2007, 05:27 AM
What does "Tryna" mean ???

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

blackie42
10-17-2007, 06:11 AM
thank - works fine - tryna s'pose its nothern UK slang for trying to.

thanks again

unmarkedhelicopter
10-17-2007, 11:16 AM
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
10-17-2007, 11:24 AM
why not show your flags guys?

unmarkedhelicopter
10-18-2007, 02:17 AM
Why ?

Bob Phillips
10-18-2007, 02:23 AM
Why not?

unmarkedhelicopter
10-18-2007, 02:44 AM
So I can pose as a Chilean ? :hi:

Bob Phillips
10-18-2007, 03:47 AM
You can even pose as English if you want.

unmarkedhelicopter
10-18-2007, 06:51 AM
S?, usted tiene raz?n, yo no hab?a pensado en esto :whistle: