I have a form having five textbox controls txt_1..txt_5. The data that
I want to assign to these controls are located in an excell sheet at
A1..A5. How is it possible to assign the first cell value to txt_1,
the second to txt_2 and so on by copying the whole cell range and then
clicking on some command button on the form? Your suggestion is highly
appreciated.

You have to add in MIcrosoft Excel Common Controls to your form.
You can refer to the online help to get the source code.



bhandaritwo (AT) yahoo (DOT) com (Ramesh Kumar Bhandari) wrote in message news:<ed1fc058.0408051631.70a4d1c0 (AT) posting (DOT) google.com>...

bhandaritwo (AT) yahoo (DOT) com (Ramesh Kumar Bhandari) wrote in message news:<ed1fc058.0408051631.70a4d1c0 (AT) posting (DOT) google.com>...
Hello Ramesh,

I've got a couple questions. Is this to be a once off event?
Or done on a regular basis? Are the Cell locations A1 to A5
consistant or do they change for the data to be used?

With the above questions answered, it will be easier to
give you answer you can use.

Regards,

Ray

Thank you all for the replies.

Finally I have solved the problem. I wanted to access the data via the
clipboard rather than directly from the excel. Using some windows API
functions I obtained the clipboard content in text format. The text
data was delimited with tabs and/or carriage returns, which I parsed
into an array. Then I sequencially filled in the textboxes in the
form. For the time being, this functionality is exactly what I was
looking for.

Regards,
Ramesh