If I want to draw a line or an arrow, the default thickness is set to 0.75, and the default color is blue. Is there a way to change these?
Thanks
If I want to draw a line or an arrow, the default thickness is set to 0.75, and the default color is blue. Is there a way to change these?
Thanks
You either quit or become really good at it. There are no other choices.
If it is a shape line. If a Chart object then you use the parent of the line instead of Shapes.Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
You do it when you create the shape or line.
example:
Syntax might need some clean-up, but this should give you the gerneral idea. Open your vb editor, click on help and in the search box type 'Shapes.Add' to get more details.Please Login or Register to view this content.
I'm I actually have to hand-draw the shapes to take notes on what's recorded in the workbook, so can't use preset parameters for shape dimensions, just wanted to see if the default line thickness can be changed before I hand draw lines, arrows....
I think you have to use the Format Shape method after the shape is drawn in Excel. But if you are going to use more than one of the same shape, you can copy the first one after you set the line width and then drag the copy to where you want it and adjust the length by dragging the node points on either end.
Ok. Sounds that good. Thanks a lot for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks