Could excel VBA have this item in user form?

[okaydoke]

Hi,

I'm wondering could VBA user form have the input box function as the picture show below?
My purpose is to make a user form with 2 parts which could submit the data into multiple rows.

example:

row 1 = form Part A + Part B1
row 2 = form Part A + Part B2
row 3 = form Part A + Part B3...etc

Each input have different rows in part B and might up to 50 rows.
Also, is it possible that not only to use this form as an input but also an record output/report as well?

Thank you all very much in advance.

 

[XLRATOR]

You can use a Listview for that.

 

[Kyle123]

Whilst you can use a listview, I'd look at using a listbox if you are all concerned about compatibility

 

[XLRATOR]

Yes Kyle's suggestion is another good approach.
so you can make your UF look like this:

Regards.

 

[okaydoke]

Whilst you can use a listview, I'd look at using a listbox if you are all concerned about compatibility

Thanks Kyle, will try and see.

 

[okaydoke]

Yes Kyle's suggestion is another good approach.
so you can make your UF look like this:
Regards.

Thanks XLRATOR. That's exactly what I wanted. I hope it not just list but also could use for input as well.