After creating UserForm1 for one Excel application, you realize that you'll want to use it again -- with a few modifications -- in another application. You do not need to recreate the form; simply ...

To enable VBA code to call code in a Visual C# project, modify the code so it is visible to COM, and then set the ReferenceAssemblyFromVbaProject property to True in the designer. For a walkthrough ...

The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that.

This code stores that value in the newValue variable. The last line of code displays the result in a pop-up message window. Minimize the VBA window and move back to Excel's main window.

What is VBA? Visual Basic for Applications, or VBA, is a Microsoft programming language that allows users to create scripts to execute certain actions, automate repetitive functions, and create custom ...

In an Excel workbook it is possible to insert a GIF, although the animation will only work when the image is inserted into a control. This can be done through Control Toolbox, Design mode and ...