Tutorial by Topics: best

We all know them, but these practices are far less obvious to someone starting to program in VBA.
This topic displays best practices that the community has learned over time.
Prefer vals, immutable objects, and methods without side effects. Reach for them first. Use vars, mutable objects, and methods with side effects when you have a specific need and justification for them. -- Programming in Scala, by Odersky, Spoon, and Venners There are more example and guid...
A unit test is the smallest testable part of an application like functions, classes, procedures, interfaces. Unit testing is a method by which individual units of source code are tested to determine if they are fit for use. Unit tests are basically written and executed by software developers to mak...
Autofilter ultimate goal is to provide in the quickest way possible data mining from hundreds or thousands of rows data in order to get the attention in the items we want to focus on. It can receive parameters such as "text/values/colors" and they can be stacked among columns. You may conn...
This article is to introduce a simple and professional practice to use Entity Framework. Simple: because it only needs one class (with one interface) Professional: because it applies SOLID architecture principles I don't wish to talk more.... let's enjoy it!
These are some API Best Practices I had been used. ParameterDetailssortSort by Single or Multiple columns. sort=email,namedirSort Ascending/Descending. dir=asc or dir=desccolumnFilter by. phone=5555555555limitItems per Page. limit=25pagePage Number. page=2api_keyAPI Key. api_key=ABCDEF123456789...

Page 1 of 2