VBA Coding Standards
Ajay
02:41
A Professional VBA developer has a tendency of writing code by following globally accepted standards. We can say that applying the name of...
20180318
20180311
How to Create own VBA Functions in Excel
Ajay
04:10
So far you all know what are functions. Functions we can say that a set of formulas to perform task. We can further split them into two typ...
20180304
Split String in Excel using VBA Coding
Ajay
03:08
When it comes splitting the string, word from the mixed data, we normally delimit the data by converting data in Text to Column feat...
20180212
Excel VBA - Use Collection Object in Userform ListBox
Ajay
01:52
Create a Userform with Listbox showing the unique items from available large data Excel. Userform in Excel are very dynamic view and u...
20180204
How to Highlight Lowest or Highest Value in Excel
Ajay
01:52
Highlight Lowest or Highest Value in your Data Set using VBA Script. It is normally required to highlight the lowest value or highest val...
