How to open a user-form using an Excel worksheet command button
Using the idea of how to open a user-from using an Excel command button, you could create worksheets called ‘Income’, ‘Expense’, ‘Capital’, etc. and then create a command button for each of these headers. Next link each command button to a macro that opens or shows the relevant user-form called ‘expense’, ‘income’, etc and you could now enter the relevant details in the form and transfer the data to the relevant worksheet and then finalize your profit & loss account including depreciation! You have kind of automated your accounts in Excel. The training video explains the first most important steps and the other steps have been in great detail in earlier videos.
Opening separate Excel worksheets with a form command button