Developer Tab in Microsoft Excel

 

Developer tab has VBA properties and tools which we use to write the macro code, to create the command button,to make the user forms, etc.

 

image 1

 

Developer tab contains 5 groups:-

 

image 2

 

a)    Code: -Through Code option, we can record the macro, use the relative references, etc. Visual Basic option is used to open the visual basic editor. We use Macro option to see all the macros which we have written. Record Macro is used to record the macro and, while recording, it records each and every step we do. We use relative references so that macros are recorded with actions relative to the initially selected cell.

image 3

 

b)    Add-Ins: -We use this option to manage the add-ins available for this file and manage the available COM add-ins.

image 4

 

c)    Controls: -We use this option to insert the form control and ActiveX controls options. Form Controls is having 12 types of button and ActiveX Controls contains 12 types of button. Form controls is used to make drop down boxes, list boxes, spinners and scroll bars. And ActiveX control is used to design the User form. To view or modify the controls properties, we use Properties option. To see the assigned code of control, we use View Code option. Run Dialog option is used to run a custom dialog box.

image 5

 

d)    XML: -We use this option to open the XML Source Task Pane to manage XML maps in the workbook. Map properties are used to view or modify XML map properties, to manage the XML expansion packs attached to this document or attach a new expansion pack and to refresh the XML data in the workbook.

image 6

 

e)    Modify: -We use this option to specify the type of document in information panel template to show in Microsoft office – compatible program.

image 7

Previous
next

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com
 



Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>