Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PROPORTIONATE DISTRIBUTION - CHALLENGING QUESTION 4 SURE | Excel Discussion (Misc queries) | |||
Here's a challenging question for you... | Excel Discussion (Misc queries) | |||
challenging question | Excel Worksheet Functions | |||
Challenging Duplicate Question... | Excel Worksheet Functions | |||
Need help on challenging question | Excel Programming |