NEWBIE needs help!!

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.

:cry:

If I understand correctly this has nothing to do with MapPoint, but go ahead. What is the formula? What version of VBA -- err are you actually in Excel?

Also try here:
http://support.microsoft.com/newsgroups/default.aspx?NewsGroup=microsoft.public.excel.prog ramming&SLCID=US&ICP=GSS3&sd=GN&id=fh;en-us;newsgroups

Eric