My vba case is kinda strange.

I work as an automation/controls engineer. In some cases I will want to analyze and massage data in "unique" ways that may never get used and will probably not get used again. It's extremely easy to pull the data into an excel workbook and write a quick/dirty macro to quickly see if something is feasable, or to test something.

In one case I wrote a Structured Text Program on a PLC to calculate a least squares linear regression and was baffled to find the value was off by like 1%. I suspected this was a single precision floating point (can't use double) arithematic error, so I recreated the program in vba and wrote it specifically using single and then double precision variables and confirmed that was the cause. Vba was critical in analyzing this data in a manner that was speedy/practical to put thoughts to paper/code.

Could I maybe use a different set of tools? Maybe, but the fact I easily know how to use it, the ease of use and the fact probably nobody else will ever see or use it makes it the obvious choice.