I have a Shape (rounded rectangle) that I want to add text, then edit the text via VBA. When I record a macro doing this, the closest I can come is code that copies new text from a cell and then selects a cell (probably where the upper left corner of the shape is located), followed by ActiveSheet.Paste. But this is too inaccurate. I want to name the shape and then control the text.
Paul
I solved it myself. Here's the code:
HTH
Please Login or Register to view this content.
Thanks
Last edited by davesexcel; 10-23-2021 at 09:36 AM.
You don't have to select it.
The code is in the sheet module.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks