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.
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.
If posting code please use code tags, see here.
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:
For the record, it simply never executed the case statement. No errors or anything. Thanks for your reply!Please Login or Register to view this content.
K
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks