Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create or change color of a (line with arrow head) with a Macro en
Hi
Can an item (a line with arrowhead as created by the Drawing function for example) be created and/or the color of it changed by an entry or entries in a Macro when certain conditions exist? If this can be done, how is it done? Thankyou Ed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create or change color of a (line with arrow head) with a Macro en
With ActiveSheet.Shapes.AddLine(240#, 190.5, 432#, 191.25) .Line.EndArrowheadStyle = msoArrowheadTriangle .Line.EndArrowheadLength = msoArrowheadLengthMedium .Line.EndArrowheadWidth = msoArrowheadWidthMedium .Name = "myLine" End With With ActiveSheet.Shapes("myLine") .Line.ForeColor.RGB = RGB(255, 0, 0) End With Tim -- Tim Williams Palo Alto, CA "Ed" wrote in message ... Hi Can an item (a line with arrowhead as created by the Drawing function for example) be created and/or the color of it changed by an entry or entries in a Macro when certain conditions exist? If this can be done, how is it done? Thankyou Ed |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create or change color of a (line with arrow head) with a Macr
Hi Tim
Thanks for the good information. My test Macro tells me I am on the right track. I looked for further help on this area of programming in the "Excel Help" on my computer. I could not find any. Where can I find more information on this area of programming (such as the line appears properly, but is protected and can't be removed or replaced with the Macro. Also, information on the placement of the line and colors.) I think I need an advanced programming handbook. Is this information available on the internet? Or where is one available? Thanks again Ed "Tim Williams" wrote: With ActiveSheet.Shapes.AddLine(240#, 190.5, 432#, 191.25) .Line.EndArrowheadStyle = msoArrowheadTriangle .Line.EndArrowheadLength = msoArrowheadLengthMedium .Line.EndArrowheadWidth = msoArrowheadWid thMedium .Name = "myLine" End With With ActiveSheet.Shapes("myLine") .Line.ForeColor.RGB = RGB(255, 0, 0) End With Tim -- Tim Williams Palo Alto, CA "Ed" wrote in message ... Hi Can an item (a line with arrowhead as created by the Drawing function for example) be created and/or the color of it changed by an entry or entries in a Macro when certain conditions exist? If this can be done, how is it done? Thankyou Ed |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create or change color of a (line with arrow head) with a Macr
Did you look in help from Excel or from the VB editor ?
I don't know why the line would be protected. Maybe you could show the code you have so far ? Lots of VBA help available on the web (searhc Google and you'll find plenty of tutorials) or in this newsgroup. Tim -- Tim Williams Palo Alto, CA "Ed" wrote in message ... Hi Tim Thanks for the good information. My test Macro tells me I am on the right track. I looked for further help on this area of programming in the "Excel Help" on my computer. I could not find any. Where can I find more information on this area of programming (such as the line appears properly, but is protected and can't be removed or replaced with the Macro. Also, information on the placement of the line and colors.) I think I need an advanced programming handbook. Is this information available on the internet? Or where is one available? Thanks again Ed "Tim Williams" wrote: With ActiveSheet.Shapes.AddLine(240#, 190.5, 432#, 191.25) .Line.EndArrowheadStyle = msoArrowheadTriangle .Line.EndArrowheadLength = msoArrowheadLengthMedium .Line.EndArrowheadWidth = msoArrowheadWid thMedium .Name = "myLine" End With With ActiveSheet.Shapes("myLine") .Line.ForeColor.RGB = RGB(255, 0, 0) End With Tim -- Tim Williams Palo Alto, CA "Ed" wrote in message ... Hi Can an item (a line with arrowhead as created by the Drawing function for example) be created and/or the color of it changed by an entry or entries in a Macro when certain conditions exist? If this can be done, how is it done? Thankyou Ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change XL2003 autofilter's arrow color | Excel Discussion (Misc queries) | |||
Moving comment box leader arrow head | Excel Discussion (Misc queries) | |||
Mouse pointer (arrow) change color? | Excel Discussion (Misc queries) | |||
How can I change the color of the drop down arrow on a filter? | Excel Discussion (Misc queries) | |||
How do I change the color of the drop down arrow when using the a. | Excel Discussion (Misc queries) |