Compile error: Procedure too large

Hi all,

I am writing a macro in my Worksheet module, however it seems that I reached the limit of lines I can add because I get a Compile error.

In the example I attached I wrote a macro that shows a message box with the content of the cell in column V every time the cell in the same row in column L is selected.

Any suggestion on how to do this if I have a very long data-set?

Thanks in advance!

Please Login or Register  to view this content.

.............................................
Thanks.gif