View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
quartz[_2_] quartz[_2_] is offline
external usenet poster
 
Posts: 441
Default Why is Not not Not?

As far as I can tell, both your "IFs" say the same thing. In your first "IF"
you have your code to execute in the "else" portion of the statement which is
like saying "Not".

HTH

"Paul Lautman" wrote:

I've was having terrible trouble trying to figure out why I couldn't get
some OLE code to work with the IBM Personal Communications Emulator.

A lot of tracing through and I found that Not wasn't working.

In the code in the attached picture, if I un-comment the line "ir = True"
then everything works fine. But as it stands (and as the picture shows),
both ir and Not ir are both True!!!

If I code:

If oia.waitforinputready(10000) Then
Else
msg = "Initialisation (check Call Entry)"
GoTo toolong
End If

Then all works as expected. But if I code:

If Not oia.waitforinputready(10000) Then
msg = "Initialisation (check Call Entry)"
GoTo toolong
End If

Then the "True" leg is always executed???

Anybody got any ideas?

Just in case anyone doesn't get the attachment, I have placed it at

http://tinyurl.com/bhx57