BUS171: Individual Assignment 4

Excel Macros are codes that are created to easily perform a task in Excel. Programming language such as "Dim" "NameField" and "InputBox" are used to create a set of prompts for the macro. Businesses and non-profit organizations need macros because it makes them more efficient. When data must be updated, using a macro will reduce tedious and time consuming work. Excel macros is an example of computer software because it is intangible software. When creating a macro, the developer must use coding/programming language to successfully create a macro.

In IA4, I learned how to create a macro and the appropriate coding language necessary to complete a macro. Macros are like interactive shortcuts that I used to update information in the data sheets. When writing out the code for the macro, I learned the terms and syntax rules to ensure the macro will work. I then recorded the macro to replace the name of the employee by doing "Command F, searching the "NameField", then click Replace All, then entering the "NewName Field" so that the original name is replaced with a new name.