VBA Resources

Share

Related resources for VBA

Introduction to Office Script9/13/2024 5:26:23 AM. Office Scripts is a feature in Microsoft Excel that allows you to automate repetitive tasks using JavaScript. This can significantly streamline your workflow by enabling you to create custom scripts t
Highlight Active Menu Item Dynamically in Angular based on Route7/19/2024 6:28:54 AM. In Angular applications, dynamically highlight active menu items based on the current route using Angular's RouterModule and routerLinkActive directive. This allows you to apply a CSS class, like
Building a Responsive Navbar with React and Bootstrap7/2/2024 5:24:04 AM. In this article, we will explore step-by-step instructions to integrate Bootstrap's powerful UI components with React's flexibility, ensuring your navigation adapts seamlessly across devices.
Creating an Autoclose Sidebar in Blazor6/24/2024 3:44:01 AM. We'll explore how to implement a auto-collapsible sidebar in Blazor.
Customizing Navbar In MVC 5 With Bootstrap4/18/2024 1:24:12 PM. Learn how to enhance the appearance and functionality of your MVC 5 web application's navigation bar using Bootstrap. Customize the navbar with CSS and Bootstrap classes for a modern, responsive u
Excel DropDownlist Change Event Using VBA11/7/2023 10:11:29 AM. This article describes how to handle the worksheet change event using VBA. The Visual Basic Editor is a program within Excel that allows you to communicate with Excel.
PowerApps Horizontal Navigation Menu Component With Submenu5/24/2023 9:08:46 AM. In this article, we will learn how to create a navigation component in powerapps. This navigation component will have submenu options as well.
Learn to Write Excel Macro - Conditional Statements8/17/2020 9:29:38 PM. In this session we will learn about Conditional Statements in VBA. Agenda: What are conditional statements ? Different conditional statements available If then else Select case
Learn to Write Excel Macro - Accessing Cell value8/17/2020 9:29:26 PM. In this session we will learn about accessing a cell value, and also writing in excel cell. We will also see how to reference different worksheets.
Learn to Write Excel Macro - Variables and Data Types8/17/2020 9:29:11 PM. Learn to Write Excel Macro - Variables and Data Types Agenda : Declaring variablesImplicit vs Explicit Declaration Commonly Used Data Types Keyword : const
How to use VLOOKUP in Excel8/8/2020 2:00:16 AM. In this video we will see how to use Excel's one of the most important and useful function VLOOKUP.
Learn to Write Excel Macro - Hello World8/8/2020 1:59:01 AM. Series : Learn to Write Excel Macro This video will focus on setting up developer environment for Excel VBA Macros and help you write a Hello World Program.
Learn to Write Excel Macro - Loops8/8/2020 1:53:49 AM. In this sesion we will talk about Loops in VBA. Agenda : What are loops ? Different loop types in VBA For While Do While
Learn to Write Excel Macro - Find Last Row and Column8/8/2020 1:52:50 AM. In this video we will learn about identifying last row and column in Excel VBA.
Learn to Write Excel Macro - Using Buttons to Run Code8/8/2020 1:51:55 AM. In this video we will see how to call a VBA subroutine using a form control Button.
A Look Into Angular 7 Navbar Application Using Bootstrap 412/10/2018 8:56:33 AM. In this article, we will learn how to set up Angular 7 and create a responsive Angular 7 application using Bootstrap.
Create Login Application In Excel Macro Using Visual Basic7/25/2017 7:14:17 AM. In this article you will learn how to create Login Application in Excel Macro using Visual Basic for Applications.
How To Set Text Alignment and Font Style In Excel Comment using EPPlus Library7/12/2017 7:19:52 AM. In this video we are learn how to set text alignment & font style in excel comment using EPPlus .net (C#) library.
MicroStation V8 VBA Programming6/23/2017 3:22:52 AM. Getting Started with VBA Programming. The recent release of MicroStation V8 introduces another automation feature, Visual Basic for Applications (VBA). This new implementation of VBA provides rapid de
Create Business Intelligence Excel Charts Using VBA And Upload To SharePoint3/16/2017 3:38:42 PM. Create Business Intelligence Excel Charts using VBA and upload to SharePoint.
Implement Excel Validations Using VBA Macro Before Uploading To SharePoint2/21/2017 12:32:50 AM. In this article, you will learn how to implement Excel validations, using VBA Macro before uploading to SharePoint.
Getting Started With Bootstrap: Part 312/24/2016 11:32:57 AM. In this article you will learn Bootstrap nav, navbar, panels, Breadcrumbs, Pagination, Pager and Progress Bars.
How to Perform Validation in User Form Using Visual Basic For Application8/15/2015 2:24:25 AM. This article shows how to perform validation in a user form using Visual Basic for Applications (VBA).
How to Handle Various Errors and Use Error Handling in Event Driven Programming8/13/2015 7:45:01 PM. This article shows how to handle various errors and use error handling in event driven programming.
Bootstrap 3 Navbar, Fixed Navbar using BootStrap 34/8/2015 3:33:36 AM. Hi Friends In this Video i will be explaining about how to use BootStrap 3 NavBar , Adding BootStap NavBar in ASP.NET MasterPage , How to Use DropDown in BootStrap 3 Navbar , How to use Form Elements in BootStrap 3 NavBar , Placing the BootStrap Navbar Fixed to the Top and Bottom of the WebForm.
How to create a COM object using VS 2008 and consume it from VB 6.0 client application: Part II9/4/2014 5:09:03 AM. In this article, we will see how to create a simple COM application in Visual Studio 2008 and how to consume it from a VB6 client application.
.NET Brings The Fun Back to Programming12/1/2013 3:53:48 PM. Today, we are all comfortable sitting in front of our high powered computers running graphical user interfaces and compiling code in sophisticated development environments.
Creating Navbar in PHP3/28/2013 12:45:12 PM. In this article I explain use of a navbar in PHP in a Twitter bootstrap.
Using Web Services with Excel in VB.NET12/1/2012 4:00:42 AM. Let's say that we want to perform some calculations on a data set stored in a database backend server.
Excel Add Images Sets For Ranges in VB.NET11/8/2012 9:51:38 AM. Here I am trying to shows how to add an images set for a given range of values in an Excel 2010 workbook.
Excel Apply Conditional Formatting in VB.NET11/8/2012 9:26:13 AM. In this article you will learn about conditional Formatting (CF) that is a tool that allows you to apply formats to a cell or range of cells.
Silverlight Tutorial: Using the Visual State Manager to create an animated navbar8/7/2008 6:00:24 AM. This article provides a step by step tutorial on using the Visual State Manager to create a nifty animated navigation bar
Using C# .NET in Excel 20031/9/2006 1:01:26 AM. This article shows how you can take advantage of Visual Studio 2003 tools to write .NET applications that work with Office 2003.

Topics