VBA Excel cannot edit the text in textbox after cut & pastespecial

Asked Mar 10 '20 at 13:19

Active Mar 10 '20 at 13:19

Viewed 131 times

I found a serious problem in my situation. Since I had the textboxes I decided to move them in the different parts of the sheet using cut & pastespecial option.

Unfortunately I noticed, that my shape is not a textbox anymore. Instead of it it has been turned into the image, where I cannot edit the text inside.

My code looks like this:

 ActiveSheet.Shapes("TextboxLocation1").Cut
 ActiveSheet.Range("AA70").PasteSpecial
 Selection.Name = "TextboxLocation1"

 ActiveSheet.Shapes("Textbox_Location2").Cut
 ActiveSheet.Range("AA71").PasteSpecial
 Selection.Name = "Textbox_Location2"

Is it possible to prevent the initial features of my shape before moving (cut & pastespecial) across the sheet? I guess, that I shall avoid the "Selection" option and use "dim" instead...

How to avoid using Select in Excel VBA

asked Mar 10 '20 at 13:19

Geographos

2

You could just change the left/top of the shape instead of `Cut`ting and `PasteSpecial`ing. – BigBen Mar 10 '20 at 13:29
I know that, but can I do it according to the cells count? – Geographos Mar 10 '20 at 14:32
What do you mean by cells count? – BigBen Mar 10 '20 at 14:34
1

Yes. Works on the same principle as `Range`. Get your cell, get it's chords and apply what @BigBen suggested – Zac Mar 10 '20 at 14:34

VBA Excel cannot edit the text in textbox after cut & pastespecial

0 Answers0