VBA code to display text in different cells

[Zimmerman]

Does anybody know of a VBA code that will display text in different cells. what i am trying to do is run a macro that will subtract cell O9 from N9 and in cell P9 have it tell me that I will need to cut however many more (this number comes from the macro) of the text in cell D9.
So the end result would be like this.
Cell O9 has 200
Cell N9 has 100
Cell D9 reads "Fort Floor Support"
Cell P9 would read "You will need to cut 100 more pieces of the Fort Floor Support"

Windows XP
Excel 2003

 

[wigi]

why do you need a macro - Excel formulas are perfectly capable to handle this.

 

[Zimmerman]

The main reason i want to go with VBA is because somehow and someway the fornulas always seem to get erased or something changed on them. I'm just trying to prevent that from happening. And i know that things can be protected but i'd rather leave the workbook unprotected for the user so in case something does need to be changed they can do it. But when the command button is clicked then it will always go back to the way it was intended.

 

[wigi]

As an example:

Sub Wigi()
    [P9] = "You will need to cut " & [O9] - [N9] & " more pieces of the " & [D9]
End Sub

 

[Zimmerman]

That works thank you