If...Elseif msgbox statements

[excelmacro]

why is this not working?

Private Sub OK_Click()
If CC Then MsgBox ("You have selected Cost Center")
If CC_Prime Then MsgBox ("You have selected Prime")
Else
MsgBox ("You must click either Cost Center or Cost Center and Primes")
End
This message was edited by excelmacro on 2002-04-25 08:41
This message was edited by excelmacro on 2002-05-03 12:23

 

[Mudface]

Try this, you needed to use a block If..Then..Else: -

Private Sub OK_Click()
If CC Then MsgBox ("You have selected Cost Center")
If CC_Prime Then
MsgBox ("You have selected Prime")
Else
MsgBox ("You must click either Cost Center or Cost Center and Primes")
End
End If
End Sub

 

[excelmacro]

now when i click on CC and then hit the ok button, it comes up with the msgbox "You have selected Cost Center" response, and then the msgbox "You must click either the Cost Center or Cost Center and Primes". It works fine though when i only check on CC_Prime or don't check either of CC or CC_Prime

 

[Jay Petrulis]

Try,

Private Sub OK_Click()
If CC Then
MsgBox ("You have selected Cost Center")
ElseIf CC_Prime Then
MsgBox ("You have selected Prime")
Else
MsgBox ("You must click either Cost Center or Cost Center and Primes")
End If
End Sub

 

[excelmacro]

Thanks. Works great.