Friday 29 June 2012

5
During the last meeting with our supervisor, we once again presented our findings for the past two weeks. Apparently, there is a glitch in our user form and it requires us to blank out the last review date so the rest of the form can still be filled out without it.



Subsequently, we also continued working on our VBA macros which involved complicated strings of codes meant to create a more versatile and creative excel document. In short, this allowed us to create forms that a normal excel spreadsheet is not capable of.



The above image shows a very typical function we were able to add via macros. It is a button which makes the entire RA seem more interactive and user friendly as compared to a normal excel whereby people tend to roam about and not complete the task.











No comments:

Post a Comment