Peruttu

VBA textbox

Hello:

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 freelancers are bidding on average $55 for this job

HussienSharaf

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

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

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

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

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

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

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)
5.2
NashTrump

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)
4.4
KellogITSolution

Hello Please Check your PMB for my bid. Regards

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

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

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

Please see detail on PMB regards

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

can do this

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

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)
3.1
softartist

quality work is provided

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

hello. I can do it for you.

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

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

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

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)
0.0
shubhoshree123

I will do it

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

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

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

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)
0.0
Kirankumargosu

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)
0.0
RemboB

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

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

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)
0.0