Thread: Compile Error ElseIf Without If.........But there is an If ! ???
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dim dim is offline
external usenet poster
  
Posts: 123
Default Compile Error ElseIf Without If.........But there is an If ! ???
Hi folks,

Can someone please try and debug this code for me? ARGHHHH!! I just don't
get it, why am I getting the compile error, there is obviously an 'If' so why
is it saying there's not?

If (Range("D9").Value) < 0 Then Range("D9").Select: Selection.ClearContents:
UserForm6.Show
ElseIf (Range("D9").Value) 125 Then Range("D9").Select:
Selection.ClearContents: UserForm6.Show
End If

Thankyou for any advice.
Reply With QuoteReply With Quote