As per this post popping up in the close review queue What I have to change this code to highlight more than one word in excel? I interpret this as here's my chunk of VB code, how do I make it do such and such instead. Doesn't seem like they are saying what they tried but since they provided their entire code block then maybe they are showing what they tried.
They are showing their work and they are saying what they need it to do that they cannot get to work, so what is appropriate to make an unbiased decision on my part on this sort of question?
I could look at the code and maybe figure out a solution but I don't deal with a lot of VB code or whatever. If this were a batch script though and I saw the code, understood what they were having trouble with, then I'm sure I'd think it makes sense and be tempted to answer myself.
What strategies or mindset is best utilized when it comes to deciding if something should be closed or not with an example such as this one that everyone could use?