Case Select & If....Then!

[davefish]

Can anyone tell me whether it's possible to run an If...Then statement within a case select function. I have a number of dependant variables that require processing in order. The first value of a single variable, is broken down via a case select statement. Each case will then have an if..AND (conjunction)..Then goto simialar to:-

Select Case Charge_rate

Case 1 to 30

If MySettings.Charge = 100 AND MySettings.Trip = 24 Then goto ........

Case 30 to 40


I get error messages every time I run. HELLP!

DaveFish

 

[robcarr]

you dont have an End if in the coding you submitted, this might be why

Thanks Rob.

 

[davefish]

Hi Rob,

Sorry, the last set of comma's ..... were to truncate my code. The problem I had was if the If statement was single line, no End If is required. I tried Block statements as well, but kept getting Errors... 'Block If with no End if...' I must have tried every combination but to no avail. ANy clues???


DaveFish