View Full Version : Alternative font types by vba
Aussiebear
12-03-2006, 03:22 AM
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
12-03-2006, 03:29 AM
Alright who's got my attachment.....
(Surely I didn't stuff it up in the upload?)
Yep I did!
Aussiebear
12-03-2006, 03:30 AM
Try this one
mdmackillop
12-03-2006, 03:32 AM
:motz2:
Aussiebear
12-03-2006, 03:34 AM
Aaarrrggghhh!!
I saved as an incorrect file format. Anyway better late than never.
Aussiebear
12-03-2006, 03:35 AM
MD go easy on me, for at my time of life, anything could happen.
mdmackillop
12-03-2006, 04:46 AM
Probably still a youngster! Isn't it time we had your picture in your profile?
Aussiebear
12-03-2006, 04:53 AM
I've got more wrinkles than a month old bed sheet
mdmackillop
12-03-2006, 05:06 AM
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
12-03-2006, 10:21 PM
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
12-04-2006, 01:23 AM
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
12-04-2006, 03:57 AM
Malcolm, I didn't write the code. You did.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.