| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to turn on Shapes conditionally?
Hi All,
Here is the scenario: (Excel 2003) 1) I have created 10 different shapes (Free Form 1 to 10) 2) If the value in H10 is equal to "Box" then I want the Free Form 1 appears at P10:T15 location 3) If the value in H10 is equal to "Table" then I want the Free Form 2 appears at P10:T15 location 4) If the value in H10 is equal to "Ball" then I want the Free Form 3 appears at P10:T15 location and so on. I want to have only one Free Form at a time. How can I do this? Thanks very much in advance for any comments. DORI |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel document with shapes on it but the shapes do not print | Excel Worksheet Functions | |||
| Conditionally format cell to turn red after lookup match | Excel Discussion (Misc queries) | |||
| Naming Auto Shapes and Creating new Shapes | Excel Discussion (Misc queries) | |||
| When drawing shapes in excel the shapes keep disappearing | Excel Discussion (Misc queries) | |||
| How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
