I feel that Harrymc downvoted and closed my question because I downvoted his answer which was incomplete and incorrect.
You have absolutely no proof any specific user downvoted your question. The user in question should have never accused you of downvoting their answer. Just as you should not be calling out any specific user for downvoting your question. Infact, you have recieved 3 downvotes and 3 upvotes, so more than a single user has downvoted your question.
The user in question is NOT a moderator, a moderator which was the second close vote, was the reason your question was actually closed. Based on the close reason the moderator selected it appears they thought it was out of scope.
I was writing an answer as he answered and I immediately knew his answer wasn't correct as I had solved the problem myself.This seems like a flagrant abuse of power and has once again pushed me away from SU.
The user in question would have been 1 of 5 individual seperate users if a moderator had not also issued a close vote. A single close vote from a moderator will close a question. This was NOT an abuse of power. You are welcome to disagree with me on that point if you want.
I know there is StackOverflow but is VBA questions not on-topic for SU? I see there is a VBA tag with lots of activity and non-closed questions which leads me to believe it is.
I suspect the community did not reopen the question for two reasons. The first the question seems like a better fit at Stack Overflow since it's more of a programming question due to the syntax error. The second reason likely is simply due to how simple of a syntax error it actually was.
HarryMC also commented it's a "beginner coding error" but I consider it a Minimal, Reproducible Example and I have been coding VBA for about 6 months now, using "Case" statements is not exactly beginnger, trust me you should see some of my earlier code!
Using case statments is actually a very basic task.
I'd also appreciate understanding of "without general interest for our readers." comment, does that mean that only questions which are of help to general public are on topic? I also consider myself very good a wording titles of question to make them likely to appear high in search results and think this doesn't apply, even if that is the rule.
You should not read to much into the user's choice of words. Since you have more than enough reputation to chat with the moderator, I suggest you do that, but this question should remain open for everyone else.
Worth pointing out that 3 seperate users, reviewed your question after your edit, and decide the question was indeed not within scope here at Super User. This review did not include the moderator nor the original user who voted to close your question. The screenshot below is the results of that review.
You indicated that "but it's not working" and provided no clarification. You did not even specify what you meant by that. The question was at best unclear even with your last edit. When I try to answer a programming question, if the error message is not provided, I consider that question to basically be unanswerable.