Drag a formula down by a macro, after a set of actions

Hello guys!

I'm sorry in advance for not knowing some of the technical language, because I'm Dutch.

I'm new here, have a lot of experience with Excel, but when it comes to Macro's I'm a bit lost. So I try to pick up some knowledge about them. For an assignment I have to adjust an Inventory tool that was partially build by someone else. I have a question regarding a new function in this tool:

To add a new product to the field I use the command button "Artikel toevoegen (Add product)" which opens a UserForm. In this Form I fill in the product information, after which I press "Aanmaken nieuw artikel (Make a new product)". After pressing that button, I would like the macro to drag down the formula (or add it to) in column H for the new product. This column represents the status of the product in the inventory.

I'm looking forward to your ideas!

Regards, Victor