Code snippet working intermittently?!

Hi All,

I'm new to this board, so please forgive me if I'm posting out of place.... I have a piece of code:

Please Login or Register  to view this content.

The first MsgBox is just so I can check that DiplexerOrNot is at 1 (Which it should be). The If...then statement just checks an activeX box value against another. My issue is that it sometimes seems to work, sometimes not. The code is inside a button click subroutine and all the other code inside this seems to work. Is there something obvious that could be causing the computer to ignore this?

For example, if LowerRejectionOne2 is 1000 and LowerBandEdge2 is 10, I would expect an MsgBox. Sometimes this works, but other times, the code just goes on it's merry way!!

Any help on this would be much appreciated

Dave

Wrap your code in Tags

Yes, if the LowerRejectionOne2.Value is < LowerBandEdge2.Value then nothing will occur, you need an else, this way iy will appear no matter what the situation.

Please Login or Register  to view this content.

Hope that helps?

Can you upload the workbook or an exmaple of one that way it'll be clearer for me to see exactly what you're doing

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Originally Posted by bscdave

Thanks OnError; would this solve my problem?

I think so - try it.

What are the risks in using End on its own?

it will destroy all variables including public ones. Might not be an issue for this workbook, but it's a bad habit to get into. (it's the code equivalent of shutting down your computer by pulling the plug out)

Val would also work since it converts the text to numbers.