I believe that this is a very elementary project, I'd do it myself but I'm on a time crunch....
- I need a function to process a textbox on VBA. What I need is the following: I want to copy an arbitrary of columns (or rows) of data from an Excel spreadsheet, and then paste the data in a VBA textbox.
The function needs to take that string I paste in the textbox, and return and list of arrays containing the data for each column (row) or some way to represent the data equivalently (for instance, you could return a string with the data separated by a blank space, and the columns are separated by a backslash)
- The function need to group the data by columns or rows, depending on the option selected in the VBA window.
- I need to use only VBA capabilities (no .NET)
- The function should also work when copying columns (or rows) of plain text such as
(tabulated columns, with a "Enter" to finish the line)
Pleas ask if you have any questions.
A little extra clarification: I need this function to be used in Word. I use several macros to perform statistical analyses, so I type the data in a VBA textbox.
Then, with the VBA script I process those data. The convention for typing the data is: the data are separated by blank space, and the columns are separated by a back slash.
What I need to do is to pass data to the script without typing it. Whichever way can be used to acquire the data without typing them, it'd be ok. Like I mentioned in the original post, the type of data I'll be dealing with is columns (rows) in Excel, and columns (rows) in plain text. My only goal is not to have to type the data. I want just to select the data and then click a button to acquire them and pass them to the VBA script as if they were typed