I'm having trouble getting a shape to contain text via a formula.
My users are entering values in a number of cells on a worksheet. On another worksheet, I'm concatenating those values (really, variables) along with pre-determined text. The result will be a paragraph of text that's properly structured.
I thought it might help my users if they could see a preview of what their completed text will look like so they could make any changes to it before they copy it and use it elsewhere.
I've tried three methods to produce this "preview window":
1. Using a snapshot with Excel's camera tool. This works but if the text exceeds the cell's dimensions, the image will end up being distorted. So unless there's a way I can continuously have code resize the snapshot, this won't work very well.
2. I've used VBA to assign a cell's value to a shape and text field, but to no avail.
3. I've tried using a regular text box and rectangle shape and have them all use this formula...
=Comments!$F$8
To be clear, this is what I typed into the formula bar for the shapes. The problem is that it only displays a portion of the text in the cell I'm referencing (about 256 characters).
I know there's a character limit in cells, but didn't know that shapes have the same problem.
So is there a workaround for this?
My users are entering values in a number of cells on a worksheet. On another worksheet, I'm concatenating those values (really, variables) along with pre-determined text. The result will be a paragraph of text that's properly structured.
I thought it might help my users if they could see a preview of what their completed text will look like so they could make any changes to it before they copy it and use it elsewhere.
I've tried three methods to produce this "preview window":
1. Using a snapshot with Excel's camera tool. This works but if the text exceeds the cell's dimensions, the image will end up being distorted. So unless there's a way I can continuously have code resize the snapshot, this won't work very well.
2. I've used VBA to assign a cell's value to a shape and text field, but to no avail.
3. I've tried using a regular text box and rectangle shape and have them all use this formula...
=Comments!$F$8
To be clear, this is what I typed into the formula bar for the shapes. The problem is that it only displays a portion of the text in the cell I'm referencing (about 256 characters).
I know there's a character limit in cells, but didn't know that shapes have the same problem.
So is there a workaround for this?
