VBA Program problem facing

Hi there,
My name is Anshuman and I am a new user to excelforum. I have a problem and I need your help.
I have written a VBA program and using in Ms.Excel. The problem is when I try to write the VBA function through the function wizard it works but when I write the function in excel worksheet cell, it doesnt execute. I do not now the reason.

Plz give solution

Hi Leith Ross,
Thanks a lot for your concern. Fortunately I tracked the error and finally got the solution. But it came after I posted the requisition. I may be facing other similar problems. I will definitely seek for your help.
Thanks a lot.

regards

Anshuman