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

Taidot: Visual Basic

Näytä lisää: 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

Tietoa työnantajasta:
( 19 arvostelua ) Los Angeles, Mexico

Projektin tunnus: #198338

21 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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

$50 USD 2 päivässä
(40 arvostelua)

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

$45 USD 3 päivässä
(45 arvostelua)

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

$80 USD 0 päivässä
(17 arvostelua)

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 Lisää

$89.95 USD 1 päivässä
(19 arvostelua)

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

$50 USD 0 päivässä
(12 arvostelua)

Hello Please Check your PMB for my bid. Regards

$35 USD 0 päivässä
(12 arvostelua)

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

$34 USD 1 päivässä
(8 arvostelua)

Please see detail on PMB regards

$80 USD 3 päivässä
(4 arvostelua)

can do this

$50 USD 1 päivässä
(1 arvostelu)

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

$50 USD 1 päivässä
(6 arvostelua)

quality work is provided

$75 USD 1 päivässä
(0 arvostelua)

hello. I can do it for you.

$30 USD 2 päivässä
(0 arvostelua)

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

$30 USD 2 päivässä
(0 arvostelua)

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 3 päivässä
(0 arvostelua)

I will do it

$30 USD 20 päivässä
(0 arvostelua)

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

$100 USD 3 päivässä
(0 arvostelua)

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 Lisää

$30 USD 0 päivässä
(0 arvostelua)

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 Lisää

$30 USD 0 päivässä
(0 arvostelua)

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

$50 USD 1 päivässä
(0 arvostelua)

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 3 päivässä
(0 arvostelua)