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

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

Projektin tunnus: #198338

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

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.1
expertMan

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

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

Hello Please Check your PMB for my bid. Regards

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

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

$34 USD 1 päivässä
(8 arvostelua)
4.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
ExactSystems

Please see detail on PMB regards

$80 USD 3 päivässä
(4 arvostelua)
4.0
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
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
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
sadikhanmail

hello. I can do it for you.

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

quality work is provided

$75 USD 1 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 [login to view URL] 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
shubhoshree123

I will do it

$30 USD 20 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
dnugraha

can do, see PM

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