Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Draw Diagonal Cell by Cell
Is it possible to activate any cell by doubleclicking it,
for the purpose of drawing a diagonal line in the next cell higher and to the left, and continue upwards diagonally until a margin is hit (such as column A, or horizonally row A.. Z... A B C D E F 1 \ 2 \ 3 \ 4 \ 5 123 Similarly, ascending to the right A B C D E F G 1 / 2 / 3 / 4 / 5 123 From any cell With Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Draw Diagonal Cell by Cell
Yes you can.
ActiveSheet.Shapes.AddLine(171.75, 260.25, 221.25, 275.25).Select expression.AddLine(BeginX, Beginy, EndX, EndY) Each cell has a left and top parameter that you can use for the begin and end points. "smandula" wrote: Is it possible to activate any cell by doubleclicking it, for the purpose of drawing a diagonal line in the next cell higher and to the left, and continue upwards diagonally until a margin is hit (such as column A, or horizonally row A.. Z... A B C D E F 1 \ 2 \ 3 \ 4 \ 5 123 Similarly, ascending to the right A B C D E F G 1 / 2 / 3 / 4 / 5 123 From any cell With Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Draw Diagonal Cell by Cell
Thanks for replying.
However, I need the draw line to be cell by cell. Therefore, some looping need be employed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
diagonal split in a cell | Excel Discussion (Misc queries) | |||
Cell split with diagonal. | Excel Discussion (Misc queries) | |||
how do I add a autoshape such as a diagonal line to a cell | Excel Discussion (Misc queries) | |||
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
Two Different Diagonal Border Colors in the Same Cell | Excel Programming |