Multiple Lines in User form text box in Separate rows

**prabhucse** · 09-05-2016, 12:21 AM

Hi,

I have a scenario as below:-

1) Create one userform with 1 text box with Multiple lines set to TRUE

2) Enter the multiple lines in the text box,
example:
4.2.2 Get & Stay Ready – File Transfer Management
4.2.3 Get & Stay Ready – Reference Data Management
4.2.4 Get & Stay Ready – Application & Security
4.2.5 Get & Stay Ready – Operational Schedules
4.2.6 Get & Stay Ready – Switch Migration and Supporting Transit Perioda

3) Those populated values in single cell to be placed into single row (based on newline??)
i.e.
Row A1 -> 4.2.2 Get & Stay Ready – File Transfer Management
4.2.3 Get & Stay Ready – Reference Data Management
4.2.4 Get & Stay Ready – Application & Security
4.2.5 Get & Stay Ready – Operational Schedules
4.2.6 Get & Stay Ready – Switch Migration and Supporting Transit Period

4) Those populated values in single cell to be placed into single row (based on newline??)
i.e.
Row A1 -> 4.2.2 Get & Stay Ready – File Transfer Management
A2 -> 4.2.3 Get & Stay Ready – Reference Data Management
A3 -> 4.2.4 Get & Stay Ready – Application & Security
A4 -> 4.2.5 Get & Stay Ready – Operational Schedules
A5 -> 4.2.6 Get & Stay Ready – Switch Migration and Supporting Transit Period

Is there any way i can do this in VBA?

Assuming the Sheet name is Sheet1, how can i accomplish this scenario?

Thanks before the reply.

**alansidman** · 09-05-2016, 12:26 AM

This appears to be a homework or class assignment.

Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.

**alansidman** · 09-05-2016, 12:28 AM

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

Multiple Lines in User form text box in Separate rows

LinkBack

Thread Tools

Display

Hybrid View