How do I extend or reduce the length of a diagonal line using VAB

K

Keith

I have an XL spreedsheet

On "sheet1" I have a basic drawing shape (a line) set at 45 degrees that I
want to change in size with respect to a value held in "sheet1" range A1

Range A1 value is changed fequently as a result of changes on other sheets
in this spreedsheet

I would like this line to be automatically resized relative to the value of
range A1 each time I visit "sheet1"

I am trying to produce this effect using VBA - but so far without success.

Can anyone provide me with the VBA code

Your help would be very much appreciated

Keith
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I constrain a line to 30 degrees? 2
How can I do a diagonal strikethrough 1
how do I use VBA to set background of a cell 2
How do I insert text over lines without extending the line length? 1
VB script line graph 1
how do i have a word on the diagonal without using wordart 4
How do I change the displayed line length in outline view? 1
Excel 2007 VBA shape fill colour problem 0

Top