If, Else, End

[ldoodle]

Hi there,

How would I convert the following code to see they are not a member of one of the specified groups? I've tried changing to If Not but it don't work.

If Group.cn = "WS Key Stage 3" or Group.cn = "WS Key Stage 4" or Group.cn = "WS Key Stage 5" or Group.cn = "WS Associate Staff" or Group.cn = "WS Teaching Staff" Then
intBlockType = "1"
End If

Thanks/...

[lmf232s]

Something like this maybe.


If Group.cn <> "WS Key Stage 3" or Group.cn <> "WS Key Stage 4" or Group.cn <> "WS Key Stage 5" or Group.cn <> "WS Associate Staff" or Group.cn <> "WS Teaching Staff" Then
intBlockType = "1"
End If

[zingmatter]

This should work:

If Not (Group.cn = "WS Key Stage 3" or Group.cn = "WS Key Stage 4" or Group.cn = "WS Key Stage 5" or Group.cn = "WS Associate Staff" or Group.cn = "WS Teaching Staff") Then
intBlockType = "1"
End If

[Ubik]

Select case
case "WS Key Stage 3"
'nope
case "WS Key Stage 4"
'nope
case "WS Key Stage 5"
'nope
case "WS Associate Staff"
'nope
case "WS Teaching Staff"
'nope
default
intBlockType = "1"
End Select