Dual Upper and Lower limits Pass/Fail

[Stevo56]

Hi, it would be most appreciated if someone could help me with this problem

With the following code there are to dynamic cell values AJ30 and AL30.
With each dynamic value there are upper and lower limits. AJ30 is one changeable value with AJ29 as its upper limit and AJ31 as its lower limit.
The same is for AL30 as the changeable value with AL29 as the Lower limit and AL31 as its upper limit.
What I would like to happen is, when both changeable values are within their respective limits to display a passed message, if either one or both are outside its limits then I would like to display a failed message with an option to retry or cancel.
If retry is selected I would like it to continue looping until a pass criteria is met. If Cancel is selected then I would like to close the active workbook.
What its actually doing is giving the passed message even if one of the changeable values is outside of the limits.
This is what I have so far: -

Please Login or Register  to view this content.

Any help would be appreciated,
Thanks in advance

[StephenR]

Why do you have an OR in the middle of your IF statement?

[Stevo56]

should that been an AND?

I'm not that great with VBA, i'm still learning.

[StephenR]

I'm only going by your question

if either one or both are outside its limits

so yes, I reckon it should!

[Stevo56]

Thanks the AND worked great, but when I press 'cancel' it just loops the same as 'Retry'

[StephenR]

Once your criteria are met, the loop should terminate. You have only specified what should happen if Retry is selected so you would need to add another clause for Cancel.

[Stevo56]

Thanks for your guidance, but I did say I would like the workbook to terminate. would this be done using Else If?
because I tried this

Please Login or Register  to view this content.

When I tried typing the else if code, I get a VBA error message "Compile Error: Expected: expression"

[StephenR]

Maybe try this for the loop bit. But there is nothing in it to vary the value or cell so why would you get a different result if you try it again?

Please Login or Register  to view this content.

[Stevo56]

The value of that cell changes because it is a mean average of a light output test from graph data, if the light source varies in brightness then this value would change hence the average light Output Cell AJ30 and the peak of the graph cell AL30. thats what the 'call ADC11' part is that is commented out.