Macro add-in to calculate product of cells

[Bala Daniel]

Hi,

my problem is fairly simple (I'm guessing). I am new to macro and it's pretty challenging.

This is what I want to do. I have few fields to fill in and I want a macro where-in I click the command button (ActiveX- developer button), it should populate the results in column (B8) (EXCEL SPREADSHET for reference)

Thanks!
Bala

[buran]

Hi, you can use simple formula in B7
=PRODUCT(B2:B6)

However, note that empty cells, logical values, and text in the array or reference are ignored, so be careful for error inputs in cells B2:B6

[Bala Daniel]

Hi Buran,

Thanks for the quick response. I agree. However this is one small part of a bigger project that I am working on and I'd appreciate if I could get help with the macro. I'd need this to help build my other formulae.

Thanks!
Bala.