Using the Binomial Distribution function in excel

**Gadam** · 10-16-2008, 05:28 PM

err....

I've just realised that I don't really know what to do with this bit of code. Could someone enlighten me on how to apply it to a spreadsheet?

**shg** · 10-16-2008, 05:30 PM

1. Copy the code from the post
2. Press Alt+F11 to open the Visual Basic Editor (VBE)
3. From the menu bar in the VBE window, do Insert > Module
4. Paste the code in the window that opens
5. Close the VBE to return to Excel

**Gadam** · 10-16-2008, 05:38 PM

Thanks a lot SHG. Without wanting to test your patience - how do I get it to perform the calculations for me now? I've followed the steps that you listed but now I'm back on a blank worksheet.

I've never used the VBA side of things before you see.

Once again - really appreciate your help mate. I can't thank you enough