Double click cell and cell contents display in a Window,Frame

[SKooLZ]

Hi all,

I need your kind help with vba code that when a cell in a certain column or range is double clicked on, it displays the target text in a pop window or frame or print object form, like an excel popup. I'm aware of various options of using coments code or data validation messages but they have character limits so of no use for me.

the reason i need an alternative that can display text up to a cells character limit as the target cell will contain pasted in email chains.

Thanks in advance.

[walruseggman]

Not sure what your "target text" will be, so it's hard to provide the full code, but the basic outline would be:

Please Login or Register  to view this content.

But I don't think that text is selectable, so maybe not what you want.

I think a better solution might just be to have VBA create the email for you with the target text in it. I can help you do that if that's the route you want to go, and a little bit more explanation of what the target text is and how it's chosen would be helpful.

[SKooLZ]

Not sure what your "target text" will be, so it's hard to provide the full code, but the basic outline would be:

Please Login or Register  to view this content.

But I don't think that text is selectable, so maybe not what you want.

I think a better solution might just be to have VBA create the email for you with the target text in it. I can help you do that if that's the route you want to go, and a little bit more explanation of what the target text is and how it's chosen would be helpful.

Hi walruseggman, thanks for your prompt response and apologies for my delayed one which was due to me nursing my poorly daughter.

The msgbox function isn't an option as is has a very low character limit and is not displaying the full contents of the target cell text.

the function is not to create an email, it's just so the user can view the cell contents is a much bigger window, and then click out of that window and proceed to doing other things in the sheet.

I was also thinking if I cannot manage to get a solution which ideally displays the entire cell text in a popup window, then maybe run code that will expand the cell so the text content is clearly readable and then retract it if they click out of the cell..I have started modules in the document but they giving me argument not optional errors too.

Preferably i would like a nice window or frame displaying the text.

I have uploaded a test spreadsheet of with ideas of what i'm trying to achieve.

Many many many thanks in advance !!

[walruseggman]

As far as I know, there isn't a way to trigger an event when the reference is to another workbook. It's possible I'm wrong, but I've had this same conversation multiple times before with no satisfactory answer, and nothing ever found on google.

Sorry I missed that detail in my original post, or I wouldn't have posted the code I did. So I don't think I have a solution for you, but wish you luck. If you do find a solution, I'd love to know about it.

[SKooLZ]

As far as I know, there isn't a way to trigger an event when the reference is to another workbook. It's possible I'm wrong, but I've had this same conversation multiple times before with no satisfactory answer, and nothing ever found on google.

Sorry I missed that detail in my original post, or I wouldn't have posted the code I did. So I don't think I have a solution for you, but wish you luck. If you do find a solution, I'd love to know about it.

This is not referencing another workbook... not sure what you mean?