Markat pratt
New Member
- Joined
- Sep 14, 2006
- Messages
- 1
hi
i am using an xls file that a friend created , when i add a time value for a job completed on one page of the workbook ,vba goes to another page in the workbook and turns a corresponding block from red to green to show that the item is now completed. my problem is i have added three more pieces of equipment to the list (using columns) when i add time to those new boxes they do not update the box on the other page .
i am not sure if i can paste an example or attach this file to this type of forum .
i think is some type of c.formatting but i am not sure how she did it,i have played with this for a few hours -clicking on cells and playing with the avaialbe functions but i can't figure it out.
i would gladly email the file to someone who could help if this post is not clear .
thanks for the help
i am using an xls file that a friend created , when i add a time value for a job completed on one page of the workbook ,vba goes to another page in the workbook and turns a corresponding block from red to green to show that the item is now completed. my problem is i have added three more pieces of equipment to the list (using columns) when i add time to those new boxes they do not update the box on the other page .
i am not sure if i can paste an example or attach this file to this type of forum .
i think is some type of c.formatting but i am not sure how she did it,i have played with this for a few hours -clicking on cells and playing with the avaialbe functions but i can't figure it out.
i would gladly email the file to someone who could help if this post is not clear .
thanks for the help