How to use a conditional function to insert an autoshape?
I want to set up a function in Excel where if the value is 1, one auto shape
(an empty ball) is inserted and if a value is 2, then another shape (a shaded ball) is inserted. Any ideas? I'm also looking for help in making the shapes (or finding a font to use) that would need to be inserted. I believe they are called rollerballs and I need an empty, a full, a half, a quarter, and a three-quarter full ball. Thanks, |
J.E. McGimpsey has a routine that does this with pictures.
Maybe you could modify it to do what you want: http://www.mcgimpsey.com/excel/lookuppics.html ToledoMichael wrote: I want to set up a function in Excel where if the value is 1, one auto shape (an empty ball) is inserted and if a value is 2, then another shape (a shaded ball) is inserted. Any ideas? I'm also looking for help in making the shapes (or finding a font to use) that would need to be inserted. I believe they are called rollerballs and I need an empty, a full, a half, a quarter, and a three-quarter full ball. Thanks, -- Dave Peterson |
All times are GMT +1. The time now is 04:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com