If you are familiar with the Mathematica notebook front end, you can develop code in that environment, then transfer it to a code box in Excel.
For more information on developing macros in Mathematica, see Creating Macros.
