News

5: Visual Basic We come to the most powerful feature Excel has to offer: Visual Basic. That's right, Visual Basic. I know what you're thinking -- you're far too advanced for Visual Basic, right?
Learn how to create a calendar in Microsoft Excel with data using a pre-designed template, Visual Basic code, or a manual method.
How to Run an Event in MS Excel If a Cell Is Selected. Microsoft Excel runs events using Visual Basic for Applications, or VBA, a programming language for writing macros. Events often run in ...
Excel controls the number of lines in such a block using the line-feed character, "CHAR (10)." Visual Basic for Applications, also called VBA, can count line numbers by counting the number of line ...
Enhancements in the .NET Framework 4 and Visual Studio 2010 make Office automation solutions easier than ever to write and deploy, in either C# or Visual Basic. In this article I present an Excel ...
This week saw a couple of improvements to Rubberduck, a project to upgrade the Visual Basic Editor (VBE) and "Bring the VBE into this century!" VBA is based on the now-deprecated "classic" Visual ...
Microsoft's Excel team takes to Reddit to answer questions and reassure users that yes, you can open up more than one Excel window at the same time.
You have an Excel 2011 spreadsheet compiling sales data and a sales report that you're writing in Word 2011: How do you get the Excel numbers into your report? Here's a simple Visual Basic macro ...
Office 2004 included support for Visual Basic for Applications (VBA). Office 2008 didn't. Now, VBA is back in Office 2011, and Rob Griffiths couldn't be happier.
Since their introduction in 2002, Microsoft's pair of .NET programming languages, C# and Visual Basic.NET, have been close siblings. Although they look very different—one uses C-style braces ...