Dear experts,
Firstly I'm sorry cauze my English is not very good so may be my description is difficult to understand.
I'm a beginner in VBA. I have to make a progress report in excel. I want to auto update fill color of shape in Sheet 1 base on data in Sheet 2. Could you make a VBA code for this. I uploaded a file, please find the attachment to get information.
Thank you so much.
i changed the layout of sheet 2 slightly to make the coding much easier
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thank humdingaling very much for your help. I will use this code and modify it a little bit for my report.
sure not a problem
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks