Hello,
Wondering if somebody could advise how to exchange text between 2 text boxes with VBA please. I have no idea where to start.
I have 2 boxes in my sheet - Text Box 1 contains the text "Series 1" and Text box 2 contains the text "Series 2". I need a macro that will convert this to Text Box 1 contains the text "Series1" and Text Box 2 contains the text "Series 2". I have another macro in my sheet that references the Text Box numbers so I think it is the text in the text boxes that needs to be switched rather than the text boxes names.
Any help with this would be much appreciated!
Thanks,
Iain
Wondering if somebody could advise how to exchange text between 2 text boxes with VBA please. I have no idea where to start.
I have 2 boxes in my sheet - Text Box 1 contains the text "Series 1" and Text box 2 contains the text "Series 2". I need a macro that will convert this to Text Box 1 contains the text "Series1" and Text Box 2 contains the text "Series 2". I have another macro in my sheet that references the Text Box numbers so I think it is the text in the text boxes that needs to be switched rather than the text boxes names.
Any help with this would be much appreciated!
Thanks,
Iain