Double Click Macro VBA - entering 'signature' user id in cells

Hi,

I have used this coding before but for a maximum of two column ranges. In this case I have 5 columns which we want to be able to be 'signed' by double-clicking and auto entering the user ID time stamp. Can anyone help fix this coding to allow for this?

Please Login or Register  to view this content.

Thank you!

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

Still not quite clear what you actually want to achieve. A screenshot is pretty useless (I'm not going to try to recreate your workbook structure from an image) - an example workbook showing what you are trying to achieve would be more useful.

If it's as simple as: when a user double-clicks a cell in columns Q:U, the username and current time are entered in that cell, then you can simply use:

Please Login or Register  to view this content.