Rajamunna

Guys,

I am new to the forums. I just got into an internship that requires a little bit of macro knowledge, and I do not know where to learn it. Do you guys know the best way to learn the basic commands of macros? Or at least a compilation of commands so I can piece together a semi-decent program?

1.) My first task is to read a column of cells containing tasks (Range(A6,E6)) and then quantify the colors of these words into a percentage. IE, there are 6 tasks written in column A6 to E6: 2 red statements saying Call Tim and Call Tom, 2 yellows saying call sally and call sue, and two black ones saying pick up the kids and rent Ironman. I want to say that the red ones qualify twice as much as the yellow ones; the yellow ones twice as much as the black ones; and the black ones simply as the base value.

= For starters, I need to figure an algorithm to establish one red one as somehow being 4/ 14 of the project.

2.) When a check mark is placed by the task saying its complete, I need to figure out a way saying that 4/14 of this project is complete. This poses as a problem because I have no idea how to read a check box.

= Confer a check mark as completing a certain percentage of the project.


I really would like to learn how to do this. I enjoy problem solving and I think if I could somehow know the basics, I can solve this problem. I just have no idea where to look .

Sincerely,

Rajamunna

JiB410

http://www.angelfire.com/biz7/julian...ans_macros.htm

Hope this helps.