Why do I have a compile error?

[bralew]

Hi ,

I got a compile error. End If without Block if - I'm flummoxed , any advice?

Please Login or Register  to view this content.

[StephenR]

If you place the IF and the THEN on the same line you don't need the END IF.

[Olly]

You need to change:

Please Login or Register  to view this content.

to either:

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

[bralew]

got this now?????????????

[bralew]

It doesn't like the end for some reason

[Olly]

You appear to have commented out:

Please Login or Register  to view this content.

[LJMetzger]

Hi bralew,

You have to put the text after the Then on the next line.

Please Login or Register  to view this content.

or get rid of the End If (which I highly discourage)

Please Login or Register  to view this content.

Even though it takes additional lines of code, I always use the first construction, because I find it a lot easier to debug, because I know I must have an 'End If' for each 'If' statement.

I hope this helps.

Lewis

[bralew]

Ive left out

Private Sub ComboBox3_Change()

because that sat the top, it the end statement that I'm having trouble with. I'll try some of the above remedies and get back to you. Gimme a sec, cheers all.

[bralew]

LJMetzer I've tried your second suggestion and still get this:

[StephenR]

All you have to do to the code you posted originally is remove the END IF (or use the alternative formulation now provided twice).

[bralew]

I've tried them all, still scratching my head???

[bralew]

It's ok, I've gone back a version, thank you all