Excel User Forms

[sglxl]

I have a MultiPage user form in excel. There are 5 pages and each page has 10 rows, each with 4 TextBoxes across. A total of 200 TextBoxes on the Multi Page User Form. Once form is completed I need to write the values to a worksheet in the same format. i.e. each row will have 4 columns across and the total rows will be 200 or the number of rows actually completed by the user.

I am using Excel 2010 with Windows 7

Many thanks for your assistance/sglxl

[nathansav]

There are quite a few, at least 2 a week of this question in the forum, search the forum for "userform data to sheet"

There are definately some

[Olly]

200 text boxes? It sounds horrible. Why not just enter data directly to worksheets?

[sglxl]

I agree but this is part of a much larger project to 'Map Accounting Codes' by different parties and need to have tight control over users etc. Not for my personal use. If it was I would have chosen the easy way around. Thanks anyway.

[Olly]

Not sure how you achieve "tighter control over users" by adding large complex userforms, rather than entering data directly to worksheets.

Anyway - looks like you have a long, boring exercise of mapping textboxes to target cell addresses...

Please Login or Register  to view this content.

[nathansav]

I did one similar for a mortgage brokers, lots of questions, i used the tag of the textbox to put its location in.

so then i just did

Please Login or Register  to view this content.

but you still have the same work in to tag them all up.