Formula with drop downs

**DatGuy** · 08-21-2013, 12:30 PM

I am trying to write my first VBA code in many many years. What I am attempting to do is have the dollar amount in column A multiplied by a preset drop down (term lengths) in column B and the sum of the dollar amount multiplied by the % equal to the drop down menu in column C (I hope that makes sense).

Example (sorry for the lines, I couldn't figure out the spacing):
A_______B_________C
$300____M2M_____$30.00
$450_____24______$292.50

I'm not sure how to write this because I would like it to automatically pre-populate column C but here is what I did (and actually I'm getting an error message about the second ActiveCell.Offset):

Please Login or Register  to view this content.

Any help would be appreciated.

Thanks!

Moderators note: code tags added for you - this time

**FDibbins** · 08-21-2013, 12:49 PM

Hi and welcome to the forum

1st, please use code tags when posting VBA code, as per Rule 3 of our Forum

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

2nd if you are running a simple calc based on a drop down/s, you dont need VBA for this, a refular formula will do it for you

**DatGuy** · 08-21-2013, 01:51 PM

The infamous rule #3! I'll remember that for next time.

Thanks for the info, I originally looked at the formulas but couldn't figure out any that fit. I'm not very familiar with drop downs and formulas so VBA seemed like a better solution. I'll circle around and look back at the formulas. I appreciate the help!!