PDA

View Full Version : use arrow in vba formula?



samuelimtech
07-17-2014, 08:43 AM
Hi all,

First of all let me say im pretty sure this is impossible but lets see if anyone comes up with a plan.
basically i have arrows pointing at cartain cell values, is it possible to get ascertain that cell reference through vba? the idea being if i move the arrow the refernce will change with it.

thanks for any help

westconn1
07-17-2014, 02:26 PM
please explain further, or better, post a sample workbook that demonstrates

Paul_Hossler
07-18-2014, 05:40 AM
I'm not sure yet how to determine which end has the arrow head, but you can find the cells under the ends at least



Sub test()
Dim shpLine As Shape
Set shpLine = ActiveSheet.Shapes(1)

MsgBox shpLine.TopLeftCell.Address
MsgBox shpLine.BottomRightCell.Address
End Sub