Hi there I'm very new to vba and I was wondering if it were possible to lengthen an existing shape for example rectangle from C2:E2, and have it go from C2:G2 by clicking a command button?
I'm attempting to create a 1 year look ahead with arrows stretching from the first month on the schedule (ie. January) to the month that activity ends. I've been able to get by so far by creating a macro that changes shape width according to where the month you want to end at is.
I run into issues though when the activity doesn't start at the first month on the schedule. When I run the macro on a shape (activity) that begins in May and ends in October the shape will take the width of a shape that runs from January to October and extend way past October.
Thanks for reading and any help would be appreciated!
I'm attempting to create a 1 year look ahead with arrows stretching from the first month on the schedule (ie. January) to the month that activity ends. I've been able to get by so far by creating a macro that changes shape width according to where the month you want to end at is.
I run into issues though when the activity doesn't start at the first month on the schedule. When I run the macro on a shape (activity) that begins in May and ends in October the shape will take the width of a shape that runs from January to October and extend way past October.
Thanks for reading and any help would be appreciated!