Skip to main content

【VBA】 T Account Generator

· One min read
Yan-Ying Liao

Download

T-Account.xlam

Demo Download

T-Account.xlsm

Demo

If you don't know how to use xlam file, here's the tutorial.

When you're trying to understand the logic behind an transaction, it's quite useful to write T-Accounts to help you. The macro is a T-Account generator which would draw a T-Account after you enter selected information. I created this add-in few months ago to learn how to combine userform with VBA code and to practice some syntaxes like offset and the way to insert Excel built-in formula into VBA.