How to display contents of a cell in UserForm and take input
 

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/

How to display contents of a cell in UserForm and take input
 

Sound like you data is in a listbox. Easiest would be to use the click
event of the listbox to put the data in a textbox and skip the cut and
paste.

Private Sub Listbox1_Click()
Textbox1.Value = Listbox1.Value
End Sub

--
Regards,
Tom Ogilvy


ssexcel wrote in message
...
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/

How to display contents of a cell in UserForm and take input
 

Tom Ogilvy wrote:
*Sound like you data is in a listbox. Easiest would be to use the
click
event of the listbox to put the data in a textbox and skip the cut
and
paste.

Private Sub Listbox1_Click()
Textbox1.Value = Listbox1.Value
End Sub
*

Tom,

I think I did not make myself clear. I already have an excel sheet
with one column of data viz MEMBERPROFILE which is a detailed writeup
about each member and is in prose form. Example George A David was
admitted as a Junior Member today. His date of birth is 20th Aug 1955.
He went to No Such School and completed his college education at No
Such College.

I want to take out these information from MEMBERPROFILE column and
populate the rest of the fields as follows:

Name George A David

DOB 08/20/1955

School No Such School

College No Such college

And since the information is already there in MEMBERPROFILE I just want
to open a userform and allow the operator to highlight each field's
content (from MEMBERPROFILE) and do a cut and paste into respective
text boxes.

The prose is not preformatted so I cannot do an extract unless I
read through the whole prose.

Thanks



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