How do i move a comment box the the left side of a cell excel 2010

As best I can tell, there is not a setting\property to change the "pop-up" location of a comment. Its' edit location can be changed, but not its pop-up location. I may be wrong.

The code below will move the comment once it is visible and you select the cell. It doesn't change the comment position when you only hover. You have to select the cell. It's based on a solution suggested by mikerickson

To install the code:

• Right-click on the sheet tab with your comments
• Select View Code from the pop-up context menu
• Paste the code below in the worksheet's code module

Please Login or Register  to view this content.

Hi AlpfaFrog,

Thanks for the advice and the code you supplied. It seems that its not possible to make a comment box display to the left of the cell so the code above is just what I want, but I have seen the code that mikerickson had posted as the code below

Please Login or Register  to view this content.

I would like to adapt both codes so on clicking on the cell with the comment it displays to the left as the code you supplied but two rows down as in the one mikerickson posted above but I am not able to adapt both commands. I just don't know where to add the bit about two rows down

Can you help me a little please

Regards

You're welcome.

Try this...

Please Login or Register  to view this content.