VBA textbox


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

2 3

4 4

3 8

1 5

(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

Skills: Visual Basic

See more: vba textbox, visual basic net arrays, vba work, vba with, m string, group m, what is vba in excel, what is vba, vba time, vba for, in vba, vba, vba excel, VBA and excel, project on vba, m group, excel to vba, crunch, backslash, Arrays, vba excel copy, net vba, vba function, selected process, text row

About the Employer:
( 19 reviews ) Los Angeles, Mexico

Project ID: #198338

21 freelancers are bidding on average $55 for this job


hi, i can finish this task with 1 or 2 days. plz check PMB thanks

$50 USD in 2 days
(40 Reviews)

VBA developer since 1997. Can do. Regards, Svet.

$45 USD in 3 days
(45 Reviews)

Have many experience work with VBA , please visit my review.

$80 USD in 0 days
(17 Reviews)

When copying a range in Exelc the default behaviour is to generate tab-delimited columns with a CrLf after each row. If the amount of data you are copying is large, you will probably want to use a RichTextBox instead f More

$89.95 USD in 1 day
(19 Reviews)

Hi there, I can provide a program to do your task (however it would not work the paste) Regards Nash

$50 USD in 0 days
(12 Reviews)

Hello Please Check your PMB for my bid. Regards

$35 USD in 0 days
(12 Reviews)

I'll be glad to work for you, Sir :-)

$34 USD in 1 day
(8 Reviews)

Please see detail on PMB regards

$80 USD in 3 days
(4 Reviews)

can do this

$50 USD in 1 day
(1 Review)

Hi We are a little confused of your requirement. Is the screen shot in PM what you want please? Regards PY & Associates

$50 USD in 1 day
(6 Reviews)

quality work is provided

$75 USD in 1 day
(0 Reviews)

hello. I can do it for you.

$30 USD in 2 days
(0 Reviews)

I am a VBA developer, willing to complete this short project for a maximum of $30.

$30 USD in 2 days
(0 Reviews)

Hello, I believe in Win-Win. It would be great to provide you my Quality work at the Win-Win Bid/Time Frame. Thank You For Reading.

$70 USD in 3 days
(0 Reviews)

I will do it

$30 USD in 20 days
(0 Reviews)

I can done in fix specified times as required and modification can be done.

$100 USD in 3 days
(0 Reviews)

The function you want is ALREADY MADE and I can deliver it to you NOW for ONLY $30. Try first, pay later. I already have the new [url removed, login to view] Master Card Debit Card. therefore; please make all payments through GAF (after More

$30 USD in 0 days
(0 Reviews)

I'VE COMPLETED IT. Select me and get it right away. I've done is based upon the assumption that the content of the cell will not have any space. I mean, i've split data as columns using space as delimiter and rows usin More

$30 USD in 0 days
(0 Reviews)

Hi, I can do this for you fast. Please see your PM for details. Rembo

$50 USD in 1 day
(0 Reviews)

I would provide the project upon payment. If desired, I could post a video on my Web site, proving that it is done and works.

$100 USD in 3 days
(0 Reviews)