I am new in VBA.Needs help urgently

if i have to create a click() function to calculate a formula, how to go about it?

I tried creating a button from forms toolbar then tried to assign the macro.but it says formula too complex to be assigned.

In the code window , i will like to know how to insert a new event for a click function and how to define it for the click() function.