User Form adding records in 2 rows at a time

Hi,

I created a user form & every thing is recording perfect, but i would like to add the information in 2 rows at a same time.
Example :

Date : 05/11/12
Part No. : ABC
Receiver : R1
Sender : S1
Quantity : 100

When i click the button to add the above records, have to add the following manner :

Date : Part No. Name Quantity
1. 05/11 ABC R1 100
2. 05/11 ABC S1 100

I have acoding for single record, but i would like to know who can i record using one form to record two different rows, but have all the information same except the name.

Waiting your reply.

Regards,

Misbah

Hi Misbah
Why don't you show us you're existing code (be sure to use Code Tags).

Hi Misbah

Please wrap your code in Code Tags...the Moderators are rather strict on this.

Rule #3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Select your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). You can also type the code tags in manually if you prefer.

Hi Misbah

Perfect.

Hi Misbah

Without seeing your workbook and UserForm, I'd suggest looking at this approach

Please Login or Register  to view this content.

If this doesn't work for you then I'll need to see the workbook with the UserForm and existing code. Let me know of issues.

Hi Misbah

You're welcome...glad I could help. If this satisfies your need, please mark your Thread as Solved.