Hello friends,
I have never posted to a forum but have benefited from the information within this site. Thanks to all who contribute your time an knowledge.... it's invaluable. My question concerns two drawing textboxes. I would like to copy the contents from textbox A to textbox B with VBA.
- Both textboxes are on the same Excel 2007 workbook in a single worksheet.
- Textbox B may contain text that would need to be deleted/cleared prior to pasting the new text from textbox A.
- The text in textbox A may vary in length and would need to be formatted to a specific font once pasted into textbox B (Ariel 10 for example).
- The original contents of textbox A would need to be deleted/cleared after pasting the text to textbox B.
Any assistance would be appreciated.
Thank you,
I have never posted to a forum but have benefited from the information within this site. Thanks to all who contribute your time an knowledge.... it's invaluable. My question concerns two drawing textboxes. I would like to copy the contents from textbox A to textbox B with VBA.
- Both textboxes are on the same Excel 2007 workbook in a single worksheet.
- Textbox B may contain text that would need to be deleted/cleared prior to pasting the new text from textbox A.
- The text in textbox A may vary in length and would need to be formatted to a specific font once pasted into textbox B (Ariel 10 for example).
- The original contents of textbox A would need to be deleted/cleared after pasting the text to textbox B.
Any assistance would be appreciated.
Thank you,