Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Line/Arrow
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Line/Arrow
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." wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combobox has no arrow, just a line on the right, what's wrong? | Excel Worksheet Functions | |||
Placing an arrow on the series line in a line chart | Charts and Charting in Excel | |||
Arrow on a line chart as a marker | Charts and Charting in Excel | |||
can i have a line with arrow? | Charts and Charting in Excel | |||
Conditional line/arrow | Excel Discussion (Misc queries) |