Pasting CSV Data into a text box and copying it to a series of text boxes

[Mr_Si]

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]

Simple solution is to use a Split function. On click of the button, you can do this.

 

[Mr_Si]

Thank you, I shall look into that.