Pasting CSV Data into a text box and copying it to a series of text boxes (1 Viewer)

Mr_Si

Registered User.
Local time
Today, 11:49
Joined
Dec 8, 2007
Messages
163
Hi all,

I have a form on which there is a series of text box controls relating to different frequencies. At the moment I enter a value in to each of these manually.

However, I would like to have an unbound text box where I can paste in all the values (6 or 8 of them) from excel and then press a button and they would be copied in to the individual boxes.

So far I have my design:



I'm not sure where to start with regard to the code as I don't know how to handle delimited text - is it column delimited in excel?

I imagine some sort of loop, such as a do until will be required but again not sure.

I would value some assistance, even just pointers of what commands to look at would be great.

Many thanks,
Simon
 

pr2-eugin

Super Moderator
Local time
Today, 11:49
Joined
Nov 30, 2011
Messages
8,498
Simple solution is to use a Split function. On click of the button, you can do this.
 

Mr_Si

Registered User.
Local time
Today, 11:49
Joined
Dec 8, 2007
Messages
163
Thank you, I shall look into that.
 

Users who are viewing this thread

Top Bottom