Dropdown List Macro activate

[Qppg]

Hello,
I am really close to doing what I need I have just run into a little problem. I have code to do what I need to do currently but it only works for one cell. If I try to get it to copy down through a range it loops endlessly back and forth between two values. I am sure that there is an easy way of accomplishing this. I would appreciate anyones help or suggstions. Thanks.

Here is the code that I am using on the worksheet

Please Login or Register  to view this content.

Now I know that the target.address is set to D2. What I would like to do is the target.address range for colum d starting with D2 going down.

I also have a module that I use to call the macros it is as follows

Please Login or Register  to view this content.

Now the same thing happens here I know. They way I have it coded will always perform the calculation in f2. What I am trying to accomplish is for every row I want to be able to select the value from the drop down list in D column and perform the caclulation in the corresponding f column of the same row.


I will also attach a copy of the file so people can look at what it is exactly that I am trying to accomplish.

Thanks again for the help

Bob

[mikerickson]

If you put

Please Login or Register  to view this content.

around the change routine, you will avoid cascading Change events.

[VBA Noob]

Maybe

Please Login or Register  to view this content.

VBA Noob

[Qppg]

Sorry forgot to attach the file.

[VBA Noob]

Did my code help

VBA Noob

[Qppg]

It helped some but if I put your code in exactly nothing would happen when I would select bulk, NNB Bulk, Cartons, or Coors. I used a varient of yours and mine and I can get the drop down to refrence the macro but I still can't figure out how to make the macro perform the calculation and place it in the right location.

Here is what I have done.

Please Login or Register  to view this content.

Also tried this in Macro 1 but it puts the value in all the F cells for the entire sheet. I know that is what I am telling it to do.

Please Login or Register  to view this content.

Thanks again for you help it is greatly appreciated.
Bob

[VBA Noob]

Your Enableevents must be set to false

Try the attached file

VBA Noob

[Qppg]

I figured it out. Thanks VBA Noob for your help.


Worksheet code

Please Login or Register  to view this content.

Module1 code

Please Login or Register  to view this content.

Thanks again for all the help
Bob

[Qppg]

Thanks VBA Noob your code works great. mine was working sometimes but not all the time. Thanks again for your help.

Bob

[VBA Noob]

Your welcome

VBA Noob