Hi, I try to fill a few cells with text in an Excel Form. Some of the text has up to 1000 characters, and the origin is on a website or a Word_document. I copy the text by CTRL+C and then use the inputbox in a VBA macro to fill the Excel-form, line by line. All works fine, but the InputBox does not accept String/Text of a length of over 256.
Even using Dim Input_X as String * 1000, does not help. It is the InputBox mask which seems not to take a strings over 256 characters when I use CTRL+V. The little input window in the InputBox simply stays empty until the length of my string is smaller than 256.
Yes, I could use 'Cells (i,10).select' (if this is my actual target cell), followed by ActiveSheet.Paste but then I need to use MsgBox before and after to stop the Macro, to allow me to know when I can use my CTRL-C and to see at which variable input I am.
The solution via inputBox is much more suitable, but restricts the text I wonna use. Can anybody help? Thanks in advance.
Even using Dim Input_X as String * 1000, does not help. It is the InputBox mask which seems not to take a strings over 256 characters when I use CTRL+V. The little input window in the InputBox simply stays empty until the length of my string is smaller than 256.
Yes, I could use 'Cells (i,10).select' (if this is my actual target cell), followed by ActiveSheet.Paste but then I need to use MsgBox before and after to stop the Macro, to allow me to know when I can use my CTRL-C and to see at which variable input I am.
The solution via inputBox is much more suitable, but restricts the text I wonna use. Can anybody help? Thanks in advance.