Reports can take many forms, as far as presenting data is concerned.
A report is any artifact created from data for end use, or as required by another system as input.
A report can be a single page summarizing information about something (see the certificate example of last week’s Blog post), it can be an order for an employee to do something (such as in a production order) and it...
Would you skip learning how to drive a car had I told you it can get you to your destination hundreds and thousand times faster than your bicycle?! I don’t think so.
Operating a vehicle may sound difficult, if not frightening, if all you’re used to is riding your bike. Still –...
Technically speaking, a recursive function calls itself as part of its program flow.
Yes, you read it correct. This is the general idea:
Function CalcSomething(…) as Long
…
X = CalcSomething(…)
…
End...
Last week I published a Blog post I thought would be all you may need in order to choose the right Inner Circle plan for you.
However, I am still getting some questions from some Excel enthusiasts about the program.
Today’s post is dedicated to those still having questions.
Q: I already learned Excel VBA and get along pretty well. Why should I...
The first Excel VBA Inner Circle monthly workshop took place two days ago.
The monthly workshop is a deep dive into some aspect of Excel VBA and SQL programming and career. I expose advanced VBA programming, code, user experience considerations, data design and processes planning, and any professional aspect having to do with Excel VBA and SQL.
...Microsoft Office is one of the most ubiquitous software serving almost every business and many individuals. In 2016, windowscentral.com estimated 1.2 Billion Office users worldwide.
When I segmented for Excel AND VBA interest in Facebook Ads Manager, Facebook found 400,000...
In case you missed it, the last month in my Blog was dedicated to data structures in computer programming and their use in Excel VBA. After we covered Enumerations, Collections and User-Defined Data Types, we close this week with a grand finale: Arrays.
An array is a memory storage structure for storing an indexed series of elements of the same data type.
This is how we would...
In my last week’s Blog post I elaborated on data types and their use in VBA.
Beyond using the readily available native data types we’re all familiar with, such as Integer, Date, String and Boolean, we can define our own, user-defined data type.
Simply put, a user-defined data type is a group...
A data type is a structure to store data with given attributes and constraints.
You are probably familiar with some popular data types defined for us in VBA, such as an Integer, String and Date.
An Integer in VBA, for example, is allocated with 2 bytes to store numbers in the range -32,768 to 32,767.
A Date in VBA is allocated with 8 bytes to store numbers representing date and...
50% Complete
Once you submit your details, you'll receive an email with a confirmation link. That's it! you're subscribed!