If..Then..Else functionality

[bsnapool]

Hi All

I am trying to get my head round the basics of VBA, and would like a full or detailed description of this functionality and how it would be used...

I have done some internet searches and found some websites but would like a detailed perspective with maybe an example??

Any help?

Thanks in advance

Andrew

 

[just_jon]

Have you looked at If in the VBA Help file?

 

[bsnapool]

Any simple description would be ok. It is just so I can get to grips with the basics....

Any help would be much appreciated...

Thanks

 

[VoG]

Perhaps a simple example might help:

If ISType = 2 Then
           I = InIS / 62500
ElseIf ISType = 3 Then
           I = InIS / 40000
ElseIf ISType = 1 Then
           I = InIS
Else
           GoTo QinErr
End If

There can be many lines of code between each If ... Else, not just one per case as here.

 

[Joe4]

You should also be able to find explanations and examples in any beginning VBA book.

 

[bsnapool]

Thankyou...

suppose an overview of this would be multiple if's???