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

"JeremyR." <(E-Mail Removed)> wrote in message
news:F4E23203-20D8-45E7-8E5C-(E-Mail Removed)...
> 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.