vba macro code error: statement invalide outside type block

**satania** · 02-20-2012, 03:29 PM

I just started working with macros and the vba code. I have read online how to do what I want but when I run the code i get an error "statement invalid outside type block". Here is my code:

Please Login or Register  to view this content.

Maybe it has to do with my msgBox it highlights the top line in yellow, but the msgBox is highlighted in blue. Any help would be great! Thanks

**satania** · 02-20-2012, 03:40 PM

Well I got rid of the error but now my code doesn't work. Back to the drawing board

**Mordred** · 02-20-2012, 03:44 PM

Does the following help?

Please Login or Register  to view this content.

**Mordred** · 02-20-2012, 03:48 PM

There were a couple of issues that you need to watch for.

When using the worksheet change event, you should toggle enable events
If you are going to reference a range like C9 then you have to explicitly call it as a range:
```
Please Login or Register  to view this content.
```

**satania** · 02-20-2012, 03:49 PM

Ah I see thanks. I haven't ran into that in any of the examples I looked at online.

**satania** · 02-20-2012, 03:55 PM

Actually using the code suggested gives me an error. I tried

Please Login or Register  to view this content.

got a run time error: method 'range' of object '_worsheet' failed. Did I miss something? I even took out the or's to see if it was messing it upso I just had one test in the if statement.