Combining two Worksheet_SelectionChange Events help!

[tabbytomo]

Hi Guys, I have one worksheet_selectionchange which tracks and logs changes to a worksheet on a different worksheet. I have a second worksheet_selectionchange which prevents users from selecting multiple cells.
I cannot for the life of me get them to work together, I can either track the changes or prevent multiple cells selection. I've copied my code below, is there anyone that can help get this working?
The code to track changes;

Please Login or Register  to view this content.

And the code to prevent multiple cell selection;

Please Login or Register  to view this content.

Thanks in advance guys, of course let me know if I've broken any rules or anything.

[Olly]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

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.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Edit your post to use the code tags, then I can post your solution. Thanks!

[tabbytomo]

Sorry about that, that should be sorted now. Look forward to reading what you've got!

[Olly]

Thanks for adding the CODE tags - it makes it much easier to read, and copy, your existing code.

Try the following:

Please Login or Register  to view this content.

It should be a little more efficient than all those if statements.

[tabbytomo]

Hi Olly, thanks for that, it still logs the training information, unfortunately I am still able to select multiple cells at once. It certainly is much easier to read and more efficient than what I'd managed to put together.

[Olly]

Apologies - I slightly misread your requirement. Change the Worksheet_SelectionChange code to:

Please Login or Register  to view this content.

[tabbytomo]

Thanks so much, that is everything working as it should be! Suppose I'll start working through the differences now and learn how to do this sort of thing for myself. Again, thank you very much.

[Olly]

Happy to help, thanks for the feedback.

[Greg M]

Hi there,

Take a look at the attached workbook and see if it does what you want.

Your code can be made a LOT simpler by listing the various Categories in a hidden worksheet instead of in the VBA CodeModule.

The code I've used is as follows:

Please Login or Register  to view this content.

Highlighted values can be altered to suit your own requirements.


The mvaTargetValues variable is used to restore original data values in the event that a User deletes or copies multiple cells in a single operation.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[Greg M]

Post deleted - duplicated due to server problems

[Greg M]

Post deleted - duplicated due to server problems