Conditional Line/Arrow

  • Thread starter Thread starter JeremyR.
  • Start date Start date
J

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.
 
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
 
Back
Top