VBA User Form needs to accept multiple lines/breaks pasted in it

Hello all!

Basically, the sheet I have records reorders for product. Currently, it only accepts one item at a time. We can copy multiple lines from our ordering software, and they can paste into Word or another Excel sheet fine. However, my user form will only accept the first line when pasted into it. Is there something I can add to my code to get it to accept multiple lines/breaks into the box?

The user form ID is frmInput

Thanks for the help!

Please Login or Register  to view this content.

Originally Posted by Norie

How/where are you entering multiple reorders?

Each reorder may consist of multiple items. We are copying these items from an inventory program called SAP, which uses spreadsheet functionality.

Lets say an order looks like this. (Numbers on the left are line items)
10 Product A
20 Accessory
30 Installation
40 Product B
50 Accessory
60 Installation

If the customer needs to return Product A, the user needs to copy lines 10-30, and paste them into the user form. Once copied, the user can paste into Word or Excel, and it will appear correctly. However, the User Form I currently have will only paste the first line. The form I created is for notating the reorder.

Thanks for the reply!

Originally Posted by Norie

So what are you actually putting in the textbox?

The users are pasting the copied values/cells from SAP. They would copy:
10 Product A
20 Accessory
30 Installation