Hi All,

Greetings !

I have a worksheet which contains data in one column (field name is
MEMBERPROFILE) and I have about 400 rows of data (which contains blanks
in the middle within this 400 rows).

I want to create a userform and allow the user to do a cut and paste
within the userform from the contents of MEMBERPROFILE.

I know to create userform and get data to save to the excel.

But I am not sure how to display the data and allow the users to do the
"cut and paste"

I would make myself clear:

I want to display the contents of MEMBERPROFILE and below it I need to
capture details of Membername, Member date of birth, Member add1,
Member add2 etc which are found in MEMBERPROFILE.

If I create a userform would it be possible for the users to highlight
the relevant text in MEMBERPROFILE and do a copy (control c) and paste
(control v) into the relevant textbox in the userform ?

And how to I display the next record when the first record's data is
completed (when submit button is pressed how do I display the next
NON-EMPTY row ?)

I would be much grateful if somebody can help me out.

Thanks in advance.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/