ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can one change shape properties conditionally? (https://www.excelbanter.com/excel-worksheet-functions/234091-can-one-change-shape-properties-conditionally.html)

Bob Arnett

Can one change shape properties conditionally?
 
Is it possible to have a shape's properties change conditionally based on the
value of certaiun cells as is possible with conditional formatting of cells?

Shane Devenshire[_2_]

Can one change shape properties conditionally?
 
Hi,

Only if you write VBA code.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Bob Arnett" wrote:

Is it possible to have a shape's properties change conditionally based on the
value of certaiun cells as is possible with conditional formatting of cells?



All times are GMT +1. The time now is 09:02 PM.

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