ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I make lines appear after entering a number in a cell? (https://www.excelbanter.com/excel-discussion-misc-queries/43674-how-do-i-make-lines-appear-after-entering-number-cell.html)

Achilleas

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?

Anne Troy

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?




Achilleas

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?






All times are GMT +1. The time now is 01:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com