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.