[Note] Sort Macro

I seem to have discovered that running my sort macro takes longer than every other macro I have. I'm not going to experiment ways to fasten it up cause it seems impossible.
When running the sort macros, it shows all the steps but in like fast motion. It finishes after approximately 2-3 seconds but it makes the program look buggy by the way it does it.

I have approximately 2 days to finish this program, and I forgot to change the sheet colours to make it more appealing! (gonk) ahhh.

Custom Sort: Success!

I've put the the options which I wanted in my custom drop list into my dataspace (changed font colour to match background) and imported the list. Suprisingly, it did it the way I wanted and in the order I wanted.
At least it's done something right.

Graph Creation Issues

Another bug, excellent(!)
Seems as if you can't create graphs in excel using data from drop down lists. Even better, I can't edit Graph data from Date of Birth so it only shows people born on like a specific year instead of the day/month/year format making it messy
Great.

CLEANUP - EDIT: I managed to fix 1 out of 2 of these problems. Graphs can be created but you have to use COUNTIF to get the figures and use your immagination to find suitable headings for your graph sections. If you want to count two different sets of data and accumilate one number, use two COUNTIFs in the same cell.

For example, Say I want to find out how many people registered in the sheet are aged 12 to 14. The formula I would enter is : =COUNTIF('Insert Sheet Name'!E7:E37,">=12")-COUNTIF('Insert Sheet Name'!E7:E37,">14")
The first countif formula is requesting excel to count how many cells in the selected sheet and range are more than or equal to 12. The - sign I assume is acting like a minus sign and is requesting excel to find how many cells in the selected sheet and range are more than 14.
[OBSERVATION] It's pretty confusing because it's suppose to be less than 14 right? I switched the sign to <14 but got a higher number to that of the original and the higher number is wrong. I'm not sure the reason as to why it's giving me that number but I suspect it has something to do with the "dash". If I have time, I'll look further into it for answers or I'll get a second opinion.

Sort Macro issues

Well, I'm reaching the final few days of my system and what better than to have bugs plaguing everything.
I'm trying to create another macro to sort a "rank" field I have. Unfortunately, they all have similar numbers on the rank excel confuses everything and sorts it wrong. I'm in a real dilemma to fix this before friday.

CLEANUP - EDIT: I was able to fix this. Luckly for me, excel has a custom list option hidden around through the excel options. It's reallly really inefficent that it's in the options and not in a place where it can be located easier.
-Sigh-. It's located through these steps:
Logo->Excel Options->Under Popluar tab there is an Edit Custom List button
You now have the option of creating a new list, using a preset list (days of the weeks, days of the weeks shortened, months, months shortened). There's also an option to import a list from cells which is useful and time efficient. That is what I ended up doing.

The Finalè

I am reaching the end of the creation of this system. The final bits that need to be done is entering the data and creating sort macros. Although most things I would of hoped to have done will not be possible, I think I have achieved my goal of the user-friendly interface I was aiming for.
All in all, it looks and runs pretty efficently.

[Abandoned] Controlling conditional formatting using checkboxes

I have decided to abandon the task of controlling the conditional formatting using checkboxes as it seems impossible to do so in excel 2007. There may be a way but as time is running out for the completion of the system, I fear I will not have time to test it (although there is a testing phase later in the year) or correct any glitches it may pose.
It's a shame really. Adding a function like that would of just increased it's uniqueness to other peoples system. I will not stop searching yet as there may be a way to do it but as outlined before, it may be too late to implement it.

Conditional Formatting on Checkbox Cells

Happy New year to everyone.
Since Christmas and The new year have past, and since I have one more week in which to finish the system with the data entered, I'm back to work on it. I was just taking a rest haha.
Well now, I'm trying to think of a way to create a validation rule which will be controlled by a checkbox cell. See, what I'm trying to do is get a cell to change to red if a checkbox is not ticked or green if it is (for a payment record system). However, I have two checkbox fields right next to each other which will open a window of oppotunity for human error (common mistake to tick the wrong box and think that the rule is broken or something). I know I'm not making it very clear but all will come to light once I find a way to get conditional formatting on checkboxes