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.