Show a label to identify a row

[laguna92651]

I have n rows of data with many columns, I need to scroll the row to see all of the columns.

Is there a way, VBA code I assume, to hover or click on a any row cell and get a label that shows the row date, which is in column C, so I know that I am on the correct row while looking at the data, without going back to the beginning of the row to check? I would prefer not to use the split screen mode.

[Richard Buttrey]

Hi,

This sheet right click event will pop up a message box with the date.

Please Login or Register  to view this content.

[laguna92651]

Thanks Richard, worked great. How would I restrict the action to a range or to only certain columns within a range. I would want the right click context menu available directly in other parts of the worksheet or range.

[Richard Buttrey]

Hi,

You could restrict to specific columns with the modification below. As an example this restricts the macro to columns F:I & M:P. Change as necessary.
If you want to restrict to rows & columns then just build in the row numbers as well

Please Login or Register  to view this content.

[laguna92651]

Thanks Richard, perfect, couldn't find where to mark it solved.