Prev: How to display description of value instead of this value?
Next: Suddenly pasting in procedures
From: Raja on 2 Jul 2008 11:19
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 :4-dontkno.

 | 
Pages: 1
Prev: How to display description of value instead of this value?
Next: Suddenly pasting in procedures