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:
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?MsgBox Val(DiplexerOrNot) ' the below stuff works intermittently!!! If LowerRejectionOne2.Value >= LowerBandEdge2.Value And DiplexerOrNot = 1 Then MsgBox ("Lower rejection point 1 on Passband 2 is within or next to the Passband. Please check."): End End If
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
Bookmarks