VBA Code to calculate the cost per/sqm and total lt

[Roampie]

Hi all

In my attached files I would like to calculate the surface area when a user click on the 1st button
The second button should calculate the amount of paint needed after pressing the Total lt button

Below is a summary of my calculations

In sheet 2 in the workbook the calculations can be found there as it is only a sample :

Total surface area (in square meters) Divided by ÷ Spreading rate of paint (in square meters per liter)
Multiplied by x Number of coats
Equals = Total litres required

Untitled.jpg

[Roampie]

Sorry ladies/gents I have uploaded the wrong pic, my bad

See below for correct one

Untitled.jpg

[sintek]

Perhaps...

Private Sub cmb1_Click()
[D7] = [D3] * [D5]
End Sub

Private Sub cmb2_Click()
[D13] = Format([D7] / [D9] * [D11], "0.00")
End Sub

[Roampie]

Perhaps...

Thanks a million sintek, working perfect

[sintek]

Coolio...Thanks for rep...mark solved...