Hi all,
I am running Excel 2003 and I am putting together a project management workbook that involves calculations as well as large amounts of text.
I am unable to use traditional linking functions to transfer large amounts of text due to the restrictions of how much text can be copied and pasted and also how much text can be viewed in merge cells without clicking on it etc etc.
I need a large amount of text from a text box on one sheet to automatically appear in a text box on another sheet.
I know that this involves control textbox's and VBA code - I just have no idea how to write VBA code. I have been able to transfer all other information between sheets using the "Paste Link" function or by recording macros.
Look forward to your responses!
Cheers,
Andrew
I am running Excel 2003 and I am putting together a project management workbook that involves calculations as well as large amounts of text.
I am unable to use traditional linking functions to transfer large amounts of text due to the restrictions of how much text can be copied and pasted and also how much text can be viewed in merge cells without clicking on it etc etc.
I need a large amount of text from a text box on one sheet to automatically appear in a text box on another sheet.
I know that this involves control textbox's and VBA code - I just have no idea how to write VBA code. I have been able to transfer all other information between sheets using the "Paste Link" function or by recording macros.
Look forward to your responses!
Cheers,
Andrew
