Unit 42 M3
The following states some of the automated features available within Excel spreadsheets. By implementing these within the spreadsheets can really benefit the end users.
Macros:
As we did this task already you can explain how you recorded the macro and how it can be useful for the user, such as repetition of tasks, saving time etc.
Moreover,…..
The recorded procedures or steps in Excel are in fact lines of codes in visual basic that can be edited and tweaked for better results. These macros can then be exported to other worksheets if you want to replicate certain actions.
For editing the lines of code, knowledge of Visual Basic is required.
Active X Control:
Within the Excel spreadsheet program one can create buttons that can operate certain tasks such as a button to go to the next record or a button to calculate the attendance percentage. These buttons are programmable according to the user needs. Such small command operations are known as Active X control. The speciality of Active X controls are that they are designed to work over the internet through web browsers such as internet explorer. ActiveX is not a programming language, but rather a set of rules for how applications should share information.
ActiveX controls have full access to the Windows operating system. This gives them much more power but can damage software or data on your machine. ActiveX controls are currently limited to Windows environments.
Active X control can be written in Visual Basic but Excel provides some via the tool box.
Control ToolBox:
These are special tools within excel that can help the user create controls within a data entry form, such as adding buttons, text box etc. The control toolbox will have some components of the Active X control as well as others. But the other controls cannot be viewed using a web browser. The diagram below shows us the similarities in the tools seen within active x and form controls.
Forms Controls ActiveX Controls
Macros:
As we did this task already you can explain how you recorded the macro and how it can be useful for the user, such as repetition of tasks, saving time etc.
Moreover,…..
The recorded procedures or steps in Excel are in fact lines of codes in visual basic that can be edited and tweaked for better results. These macros can then be exported to other worksheets if you want to replicate certain actions.
For editing the lines of code, knowledge of Visual Basic is required.
Active X Control:
Within the Excel spreadsheet program one can create buttons that can operate certain tasks such as a button to go to the next record or a button to calculate the attendance percentage. These buttons are programmable according to the user needs. Such small command operations are known as Active X control. The speciality of Active X controls are that they are designed to work over the internet through web browsers such as internet explorer. ActiveX is not a programming language, but rather a set of rules for how applications should share information.
ActiveX controls have full access to the Windows operating system. This gives them much more power but can damage software or data on your machine. ActiveX controls are currently limited to Windows environments.
Active X control can be written in Visual Basic but Excel provides some via the tool box.
Control ToolBox:
These are special tools within excel that can help the user create controls within a data entry form, such as adding buttons, text box etc. The control toolbox will have some components of the Active X control as well as others. But the other controls cannot be viewed using a web browser. The diagram below shows us the similarities in the tools seen within active x and form controls.
Forms Controls ActiveX Controls