Limit macro to only run if certain cells are selected

One way:

Please Login or Register  to view this content.

Regards

Thank you TMShucks, that has made it much better than the errors I've been getting.
Is there any way this can be extended so that I can select a cell in column C as well as column D?

Columns("D") => Columns("C:D") and adjust the warning message.

But when I tried that and amended the data in column C, I got a #VALUE! error.

Your choice

The #VALUE! error is the error I'm trying to avoid.
You have been a great help,thanks again but I will leave this unsolved for now and hopefully someone else will have time to look at it.

thanks snb but that code gives me a syntax error!

Dunno how he does it, but snb must write his code on the fly!

Please Login or Register  to view this content.

Hi Stephen, thanks for that code, the error no longer appears but the code doesn’t change anything either!

@StephenR

That's correct, your analysis of my code as well as your observation.
That's why my thoughts are in the next code line while my fingers are are still struggling in the actual. Thank you for filling the gaps.

No, see my last edited post.

Yes, that's the necessary change I made in the code in the same post.

I have attached a workbook with your code inside, please try selecting a cell in column C and then running the macro.

But column C is all text.

The idea was that you can also select the product/s in column C to alter the cell to the right of it in column D, the code I was using already adjusted column D so I assumed that making it work from column C wouldn’t be too difficult.
That's the problem with having very little knowledge of VBA, assuming things probably isn’t a good idea.

snb will see you right.

If you want to be able to select column C to increase the value in column D, you could try this:

Please Login or Register  to view this content.

However, note that, if you selected cells in column C and column D on the same row, the increase would be applied twice ... once for the cl in column C and once for the cl in column D (cl.offset(0,1).value).

To overcome this, you could set a "flag" to indicate the cell has been updated and check this before updating a second time.

The code is starting to get a little more complex ...

Please Login or Register  to view this content.

Hope this does what you want.

Regards

or

Please Login or Register  to view this content.

Thank you so much TMShucks, for the initial error fix and your new code that works exactly as I wanted it to, with one exception. I never even thought about the possibility of someone selecting both C & D cells so I guess you anticipated my next question and provided the solution before I even asked it... scary!
Many thanks also to both Stephen and the genius snb, it obviously takes a certain level of expertise to come up with clever coding like this and your time and patience is very much appreciated.

You're welcome. Thanks for the feedback.

@snb ... neat!