Using VBA to add a value to shape

[Joe Spy]

My Alzheimer's is kicking in again. I've done this before, but now can't figure it out. How do I take a value in a cell on a worksheet and, using VBA, populate a NAMED shape with that value, updating it anytime the value is changed in the original cell. Thanks.

-- Joe

[VBA Noob]

Just wonder why you need VBA. Could you not just select the shape and in the formula bar enter =A1

If you must use code maybe this event macro

Please Login or Register  to view this content.

VBA Noob