VBA Form set up with multiple data entry on worksheet

[bsljoanne]

HI All Excel Master ,


I am a beginner of VBA. I may need your help on below form script setting.

How can i arrange a from with multiple row and column data entry at 1 form data entry?

Thanks.


e.g.
==============================
User forms

Name: John
Age: 18
Number start : 201001
Number end: 201005
Status: N/A

===========================

Worksheet 1
Name Age Number Status
John 18 201001 N/A
John 18 201002 N/A
John 18 201003 N/A
John 18 201004 N/A
John 18 201005 N/A

[BadlySpelledBuoy]

It would be helpful if you could attach your file with the form.

BSB

[torachan]

UserForm attached

[bsljoanne]

UserForm attached

HI Tora,

Thanks a lot for your help.

I would study through your form.