IF ElseIF

[taltyr]

Any Ideas why this only works for the first case and although it seems to work for the others on Step Through it does not change the values of PramA and PramB

         If Loading = "F" Then
                 PramA = 1 And PramB = 0
                                 
                 ElseIf Loading = "B" Then
                 PramA = 0 And PramB = 100
                
                 Else
                 PramA = 1000 And PramB = 1
                 End If
   
                 MsgBox PramA & PramB

Thanks you in advance

taltyr

 

[RoryA]

That won't work - 'And' doesn't work like that. You need:

  If Loading = "F" Then
          PramA = 1 
          PramB = 0
                                 
   ElseIf Loading = "B" Then
          PramA = 0
          PramB = 100
                
   Else
          PramA = 1000
          PramB = 1
   End If
   
   MsgBox PramA & PramB

 

[taltyr]

Thank you, that worked fine.

Easy for those who know how I guess. Impossible for those of us who don't.

Regards

taltyr