Is there a way to update a cell's value to match the formatted text of a shape, and vice versa? Ultimately I'd like to allow a user to edit the text and formatting from within either a shape or a cell, using VBA to keep the two in sync. Below is just a simple test that didn't work.

Please Login or Register  to view this content.