Tags » Vba

Introduction to VBA

What is VBA ?????
A program that controls and give instruction to Excel to perform functions.

What can be done with VBA?? 24 more words

Excel VBA

Immediate requirement for Senior Commercial Analyst


The key purpose of the role is to develop and maintain pricing and costing models for business opportunities valued between £1m and £500m that company competes for with other businesses and to maintain pricing data for existing contracts. 469 more words

Job Postiongs

Spearman's Rank Correlation (VBA)

Spearman’s Rank Correlation Coefficient (a.k.a Spearman’s Rho) is a nonparametric measure of the statistical dependence between two variables. Spearman’s Rank Correlation is much more powerful than than Pearson’s Correlation (what people normally think of when they think “correlation”) because Spearman’s Rank Correlation captures non-linear relationships (as long as they’re monotonic) whilst Pearson’s Correlation only caters for linear relationships. 926 more words

General

Annual MS Access tasks - and my blood pressure

I have a customer who is using a 17 year old MS Access application.  I have been supporting it for a couple years now.  supporting meaning when something needs to be updated or when somethings does not work and Access gives error messages – I need to figure out why, fix it and move on. 785 more words

MS Access

Excel ForceFullCalculation: Trading off Editing speed vs Calculation speed

A recent post at Stack Overflow reminded me that I have not posted about the pros and cons of Excel’s Workbook.ForceFullCalculation property.

So what does Workbook.ForceFullCalculation do? 526 more words

VBA

Object Oriented VBA: Delegates

In .NET, a Delegate is a reference type. A reference type points to something – typically an object. A Delegate, however, points to a method… 874 more words

VBA

The Versatile Blogger Award

Hello readers!

So The Writers In Tandem have been nominated for The Versatile Blogger Award! Huge thanks to LOU & HOSHUA’S ADVENTURES, the bloggers that nominated us! 578 more words

David And Abby