This Excel macro can list all files from zip file. Click here if you need to list all files in a folder […]

The editBox element specifies an edit box control that allows a user to enter a string of text. Graphical View of editBox Attributes The […]

The button element is the most well known of all the tools in the developer’s toolbox, it specifies a standard push-button control […]

The toggleButton Element specifies a toggle button control that can be toggled between the pressed and un-pressed states by the end-user. Graphical […]

The comboBox element specifies a standard combo box control that allows a user to input a text string or select one from a list. […]

The dropDown element specifies a drop-down control that allows users to make a selection from a list of options. A drop-down control […]

Sometimes, Excel's built-in find-replace function doesn't meet our needs, and this time you can consider using regular expressions in Excel. To use […]

Microsoft Visual Basic for Applications (VBA) is the version of Visual Basic that ships with Microsoft Office. In Microsoft Office 2010, VBA […]

A naming conflict occurs when you try to create or use an identifier that was previously defined. In some cases, naming conflicts […]

Is there  a event to handle the renaming of a worksheet? Unfortunately, the Excel object model does not provide any events for […]

You can call a procedure located in any module in the same project as the active module just as you would call […]

You will learn: What is VBA, What Can You Do With VBA, Technical Requirements, Enable the Developer tab and The Group of the Developer tab.