Alternative font types by vba

[Aussiebear]

In an earlier post "Manual override via checkbox" it was suggested that I could use an alternative font function to either post a tick mark or make a comment

On MD's invitation I have constructed a Q & A type worksheet which uses MD's code. Column A is simply a mathematical question, Column B is a supplied answer, and Column C uses the alternative font styles. Feel free to delete any of the values in the range C1:C3 to try this out.

Note: "a" in one of these cells will give you a tick.

Ted

[Aussiebear]

Alright who's got my attachment.....

(Surely I didn't stuff it up in the upload?)

Yep I did!

[Aussiebear]

Try this one

[mdmackillop]

[Aussiebear]

Aaarrrggghhh!!

I saved as an incorrect file format. Anyway better late than never.

[Aussiebear]

MD go easy on me, for at my time of life, anything could happen.

[mdmackillop]

Probably still a youngster! Isn't it time we had your picture in your profile?

[Aussiebear]

I've got more wrinkles than a month old bed sheet

[mdmackillop]

Hi Ted
Time for the next bit. Use Evaluate, Trim and a little string manipulation to check your answers. (I've hidden the code meantime to avoid temptation)

[Aussiebear]

Hmm.... just guessing here but you'd be a handful at christmas time when handing out the presents, wouldn't you?

The first bit that I presented isn't right then to compound matters, you want me to do something with Evaluate, Trim and string manipulation..... then you hide the code

[mdmackillop]

Hi Ted,
Your code example is basically fine. I think it should apply to C2:C4 though, and for pactical purposes to the whole of column C, but only run if there is a value in B.
I can certainly see circumstances where it would be useful to check an entered figure against totals/calculations from other cells and enter a tick or other comment.
Happy to supply the password to the code at any time!

[Aussiebear]

Malcolm, I didn't write the code. You did.