| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I make lines appear after entering a number in a cell?
I am trying to make lines or shapes appear or disappear, depending on which
number I put in a cell. How do I do that please? |
|
#2
|
|||
|
|||
|
Lines means borders? If so, Format--Conditional formatting. Shapes? That
would have to be done with code. ************ Anne Troy www.OfficeArticles.com "Achilleas" wrote in message ... I am trying to make lines or shapes appear or disappear, depending on which number I put in a cell. How do I do that please? |
|
#3
|
|||
|
|||
|
Well I am trying to draw some shapes using lines basically from the draw
tool. I want to be able to change certain lines and make them appear or dissapear or change place when a certain cell has a certain value in it. Is that something that needs coding? IF yes where can I learn? I haven't used VB before. Thank you. "Anne Troy" wrote: Lines means borders? If so, Format--Conditional formatting. Shapes? That would have to be done with code. ************ Anne Troy www.OfficeArticles.com "Achilleas" wrote in message ... I am trying to make lines or shapes appear or disappear, depending on which number I put in a cell. How do I do that please? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of labels on X-axis one more than number of values on Y-axi | Charts and Charting in Excel | |||
| whole lines are disappearing before I finish entering data | Excel Discussion (Misc queries) | |||
| How can I make a cell a certain color dependent on number value? | Excel Discussion (Misc queries) | |||
| How can I make a number e.g. "14" appear as a word e.g. "fourteen. | Excel Worksheet Functions | |||
| Maximum number of rows? | Excel Discussion (Misc queries) | |||
Linear Mode
