Nested Case statements... I broke it!

[keithwins]

This worked before, and then I tried to clean it up by changing it to nested case statements, and now it's broken. I can't tell if I've simply left EnableEvents False or something like that, though I've tried to fix that. It gets to the 1st and 2nd MsgBox, but never appears to enter the case statement. It may be that I did something strange to Excel, I'm very new to VBA and macros. Thanks any help! The old working code is TempFunc below.

Please Login or Register  to view this content.

[Norie]

How is it 'broken'?

Are you getting errors or is the code not doing what it's supposed to do?

If it's the latter try setting a breakpoint at the start of the code (F9) and then step through (F9) to see what's happening.

[keithwins]

Oops, I had moved my If statement condition over to my case statement incorrectly. Sorry. The beginning of the case statement should have looked something like this:

Please Login or Register  to view this content.

For the record, it simply never executed the case statement. No errors or anything. Thanks for your reply!

K