Quite the challenging question
 

Hello!
Is there any way to inlcude a table inside a comment?
If the table could have borders and everything, that would be great.
If not, I will be happy to include columns of a given width within the
comment.
Thanks in advance,
Albert

Quite the challenging question
 

First use a non-proportional font to create even horizontal spacing. Then
include CHR(10)'s to create the verical spacing.
--
Gary's Student


"Albert" wrote:

Hello!
Is there any way to inlcude a table inside a comment?
If the table could have borders and everything, that would be great.
If not, I will be happy to include columns of a given width within the
comment.
Thanks in advance,
Albert

Quite the challenging question
 

Hi Albert

Not that I know
Maybe you can do it with a picture
http://www.contextures.com/xlcomments02.html#Picture

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Albert" wrote in message ...
Hello!
Is there any way to inlcude a table inside a comment?
If the table could have borders and everything, that would be great.
If not, I will be happy to include columns of a given width within the
comment.
Thanks in advance,
Albert

Quite the challenging question
 

and then take a look at this demo on how to dynamically change pictures that are
actually charts and tables.
http://www.westnet.net.au/balson/Mod...20charting.zip

--


Gary


"Ron de Bruin" wrote in message
...
Hi Albert

Not that I know
Maybe you can do it with a picture
http://www.contextures.com/xlcomments02.html#Picture

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Albert" wrote in message
...
Hello!
Is there any way to inlcude a table inside a comment?
If the table could have borders and everything, that would be great.
If not, I will be happy to include columns of a given width within the
comment.
Thanks in advance,
Albert

Quite the challenging question
 

forgot the link to the site that describes the technique. it's quite innovative,
i thought.

http://www.westnet.net.au/balson/Mod...odelling.shtml

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
and then take a look at this demo on how to dynamically change pictures that
are actually charts and tables.
http://www.westnet.net.au/balson/Mod...20charting.zip

--


Gary


"Ron de Bruin" wrote in message
...
Hi Albert

Not that I know
Maybe you can do it with a picture
http://www.contextures.com/xlcomments02.html#Picture

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Albert" wrote in message
...
Hello!
Is there any way to inlcude a table inside a comment?
If the table could have borders and everything, that would be great.
If not, I will be happy to include columns of a given width within the
comment.
Thanks in advance,
Albert

Quite the challenging question
 

Select the range then SHIFT + EditCopy PictureAs shown on screenPicture

Open the clipboard by StartRun clipbrd.exe

Save As myname.clp

Use your favorite graphics conversion program to convert myname.clp to
myname.jpg

I use IrfanView from http://www.irfanview.com/

Now.......to the comment.

Insert a comment and right-click on edge of comment and Format CommentColors
and LinesClick on the drop-down and "Fill Effects"Picture.

Browse to myname.jpg and d-click and you're done.


Gord Dibben MS Excel MVP

On Sat, 26 Aug 2006 20:13:18 +0200, "Ron de Bruin"
wrote:

Hi Albert

Not that I know
Maybe you can do it with a picture
http://www.contextures.com/xlcomments02.html#Picture

Quite the challenging question
 

Gary

Can you insert a picture into a xell Comment using this method?

I have tried with the Camera Tool which gives a dynamic picture, but cannot get
it into a Comment.


Gord

On Sat, 26 Aug 2006 14:32:59 -0400, "Gary Keramidas" <GKeramidasATmsn.com
wrote:

forgot the link to the site that describes the technique. it's quite innovative,
i thought.

http://www.westnet.net.au/balson/Mod...odelling.shtml

Quite the challenging question
 

i have no idea, i just thought that was interesting.
sorry

--


Gary Keramidas


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Gary

Can you insert a picture into a xell Comment using this method?

I have tried with the Camera Tool which gives a dynamic picture, but
cannot get
it into a Comment.


Gord

On Sat, 26 Aug 2006 14:32:59 -0400, "Gary Keramidas" <GKeramidasATmsn.com
wrote:

forgot the link to the site that describes the technique. it's quite
innovative,
i thought.

http://www.westnet.net.au/balson/Mod...odelling.shtml

Quite the challenging question
 

No need to apologize.

I was just curious and thought maybe you had used the method.


Gord

On Sat, 26 Aug 2006 15:57:43 -0400, "GKeramidas" wrote:

i have no idea, i just thought that was interesting.
sorry

Gord Dibben MS Excel MVP

Quite the challenging question
 

i'm not that sophisticated in excel<g

--


Gary Keramidas


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
No need to apologize.

I was just curious and thought maybe you had used the method.


Gord

On Sat, 26 Aug 2006 15:57:43 -0400, "GKeramidas"
wrote:

i have no idea, i just thought that was interesting.
sorry

Gord Dibben MS Excel MVP

Quite the challenging question
 

Gord,
This is quite a neat trick.
One comment: when I try it, the resulting table image is a bit fuzzy.
Is there a way to improve the resolution of the comment image?
Thanks

"Gord Dibben" wrote:

Select the range then SHIFT + EditCopy PictureAs shown on screenPicture

Open the clipboard by StartRun clipbrd.exe

Save As myname.clp

Use your favorite graphics conversion program to convert myname.clp to
myname.jpg

I use IrfanView from http://www.irfanview.com/

Now.......to the comment.

Insert a comment and right-click on edge of comment and Format CommentColors
and LinesClick on the drop-down and "Fill Effects"Picture.

Browse to myname.jpg and d-click and you're done.


Gord Dibben MS Excel MVP

On Sat, 26 Aug 2006 20:13:18 +0200, "Ron de Bruin"
wrote:

Hi Albert

Not that I know
Maybe you can do it with a picture
http://www.contextures.com/xlcomments02.html#Picture