VBA
Pages:
1
| 2
Next >
Visual Basic Development Resources arranged by category
VBA
VBA Select Case - Using VBA Select Case Statement in Excel
The VBA Select Case Statement is an important construct in the VBA language. The Select Case statement in VBA allows the program to execute one set of statement... [read more]
Very Simple Job Excel - Vba - Macro
Very simple job Excel - VBA - Macro - Visual Basic - VB Please see the attached spreadsheet with all details. Thanks Related posts:Looking For A Developer... [read more]
Multithreaded VBA - An Approach To Processing Using VBScript
Today’s guest post is authored by Daniel Ferry, a longtime professional Excel developer and consultant (and a newbie blogger). A few months ago, I wrote a pos... [read more]
VBA Select Case - Using VBA Select Case Statement in Excel
The VBA Select Case Statement is an important construct in the VBA language. The Select Case statement in VBA allows the program to execute one set of statement... [read more]
Control Chart in Excel Using VBA - Six Sigma Control Chart Code & Software
In Six Sigma Control charts using Excel we saw how to make control charts using named ranges. From there on, it was a short hop to porting the logic to VBA. So ... [read more]
Excel install a 15 day trial to it to put it in the internet
I have a program i made in excel i want to install it on my web site Related posts:Very Simple Job Excel – Vba – Macro Very simple job Excel - V... [read more]
VBA IF Function - Using IF, ELSE:, ELSEIF, IF THEN in VBA code
The IF function in VBA is one of the most frequently used of all statements. The IF function checks if the specified condition is being met or not. The IF funct... [read more]
VBA scripting
We urgently need a small VBA application for MS Access. Employee table First name John Fred Last name Brown Smith... Related posts:Microsoft Access VBA Exclu... [read more]
Multithreaded VBA - An Approach To Processing Using VBScript
Today’s guest post is authored by Daniel Ferry, a longtime professional Excel developer and consultant (and a newbie blogger). A few months ago, I wrote a pos... [read more]
VBA IF Function - Using IF, ELSE:, ELSEIF, IF THEN in VBA code
The IF function in VBA is one of the most frequently used of all statements. The IF function checks if the specified condition is being met or not. The IF funct... [read more]
Find And Replace String Using VBA Code
There are several ways to replace string using VBA code, by looping each cell or by using VBA Replace function. Let's say that we want to replace "Macros... [read more]
Slicer VBA Code - Create, Change or Modify a Pivot Table Slicer using VBA
Here is some VBA code that can help you automate working with a slicer in Excel. Slicers, as you would know, are the latest introduction to Excel. As I mentione... [read more]
3 Things to remember before Excel VBA Job Interview
Like giving interview is a skill, taking interview is another great skill. Ashish Jain have taken many interviews in the past and given more than he has taken a... [read more]
NEED BASIC EXCEL REPORTING SHEET MAYBE VBA / MACRO
HI HERE IS THE PROJECT. MY BOSS HAS +/- 40 SHOPS. THERE ARE +/- 11 MANAGERS. EACH MANAGER MANAGES +/- 2 TO 5 SHOPS. EVERY WEEK MY COLLEAGUE RECEIVES ... [read more]
Excel VBA Example: Date Calculations
To add or subtract an interval (a relative date) from a date, we could use DateAdd function. The syntax is: DateAdd(interval, number, date) The DateAdd functio... [read more]
Next >