Conditional Line/Arrow

[JeremyR.]

In cell E:23 I have a selection button to choose between two options. I want
to add an arrow to visually help the user know which criteria he is using
based on this drop down box. I am trying to do this in visual basic but do
not know the proper code.

I have two arrows drawn. One is Line 25 & the other is Line 26.

When the cell value = option 1, I want line 25 visible and line 26 not
visible.
When the cell value = option 2, I want line 25 not visible and line 26
visible.

Any help would be appriciated.

 

[Patrick Molloy]

if range("E23").Value = 1 then
shapes("Line 25").Visible = true
shapes("Line 26").Visible = false
else
shapes("Line 26").Visible = true
shapes("Line 25").Visible = false
end if