Multiple Rules for Worksheet_Change

[V8Maverick]

I want to have a VBA code on a worksheet that monitors multiple cells and executes the appropriate macro is any are changed to "Yes" from the drop-down. The current code:

Please Login or Register  to view this content.

Appears to run MIFAC if any of D14, D15, D16 or D17 are changed to "Yes", not just D14.

I have tried doubling up the whole code, which just results in an ambiguous name error, and have tried to use:

Please Login or Register  to view this content.

But this results in both MIFAC and BFGFAC being run if either D14 or D15 are selected as yes.

What I want is that if D14 is Yes then MIFAC is run, if D15 is Yes then BFGFAC is run and if D16 is Yes then KORFAC is run.

Do-able?
I'm not a VB master, in fact I'm pretty much learning as I go.
Any assistance gladly accepted.

[V8Maverick]

Hi,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Please edit it accordingly and then we will respond.

Thanks.

As requested. Thanks for guidance

[romperstomper]

Thank you.

The problem is you are checking the cell value, not its address:

Please Login or Register  to view this content.

checks if the target cell value is equal to the value in D14.
What you want is something like:

Please Login or Register  to view this content.

for example.

[V8Maverick]

A quick and easy reply, thanks. Next problem, I have a user input box which requests a value, but does not accept decimal points - E.g. User Inputs 2.5, it dumps 2.0 into the cell.

Please Login or Register  to view this content.

Thanks for the continued assistance.

[romperstomper]

You declared your variable as a Long Integer so it only accepts whole numbers. Declare it as Double instead.

[V8Maverick]

Marvellous, Thankyou!