VBA Lightbox? Code and Examples

[sjc4]

I have several cells filled with text. Is it possible to assign a Lightbox Macro to each of these cells so that when I double click them the text expands and comes forward (per se, the text "Lightboxes")?

here is an example of Lightbox if you don't know what it is:

http://www.blog.methodsinexcel.co.uk/2009/07/31/excel-lightbox-viewer/
http://www.juiceanalytics.com/writing/lightboxing-images-in-excel/

 

[sjc4]

precicsley. displaying a text box would be the ideal situation. like you said, that is the way it is also done on the internet. do you have any ideas on how to display a text box?

 

[Norie]

That isn't quite the way it's done on the internet.

For images the larger image is usually stored somewhere on the server and for text it's really a section of HTML that's displayed.

So you would need to store images and some sort of shape/textbox for every part of the worksheet/workbook you wanted this to work for.

I suppose it could be done but it would take a lot of effort as far as I can see.

 

[sjc4]

right, got it about the internet.

now if i could only lightbox a cell... hmmm any other suggestions out there?

 

[Norie]

There would be nothing stopping you adding a textbox with the text you want using code.

All I'm saying is that to make it work for a whole worksheet could take a lot of work to do the formatting/sizing etc.

 

[sjc4]

yes, you are right. your code is excellent. if there was a wa so that i could capture all the text in the cell, not just the text shown, it would be perfect.

 

[Norie]

What exactly will be in the cells?

The only other thing I can think of with the copy picture idea would be to copy the range to be displayed to another worksheet, do the formatting there etc.

Not sure if doing that is really worth it.

 

[sjc4]

i have a matrix chart that is about 60 by 20. there is a lot of text in some of the cells, while others simply have numbers. i want to lightbox the cells that have text in them so that i can keep the chart small. a lightbox would allow the text to be easily read -- i.e. one double click lightboxes the text cell -- without comprimising the size and shape of the matrix chart.

What exactly will be in the cells?

The only other thing I can think of with the copy picture idea would be to copy the range to be displayed to another worksheet, do the formatting there etc.

Not sure if doing that is really worth it.

 

[Norie]

I thought you had other data you wanted displayed.

The code I posted displays the content if the cell.

Is there more to it in your worksheet?

 

[sjc4]

the code you posted only displayed the text that was initally visible. however, it did not display the text that was not visible -- i.e. when a cell with text is shrunk, not all of the text can been seen as some of it is hidden when the cell is shrunk. all of the text can then only be seen if the cell's height and width are adjusted, or if the formula bar is read.

 

[sjc4]

your VBA, which was very clever and has potential, does not display the text that is not visible when a cell with text is shrunk.

the code you posted only displayed the text that was initally visible. however, it did not display the text that was not visible -- i.e. when a cell with text is shrunk, not all of the text can been seen as some of it is hidden when the cell is shrunk. all of the text can then only be seen if the cell's height and width are adjusted, or if the formula bar is read.