Creating a user form.....

**Blake 7** · 09-22-2011, 11:44 AM

Hi Guys - How's it going.

A pal of mine works p/t for a charity and has asked me to create an excel userform for the attached word doc.

150 people have filled in this form and he now has to manually enter the data collected.

In the future - he would like to be able to email an excel user form rather than word docs.

I've never created one before but last night did an online tutorial from contextures. Could someone please take a look at this and let me know where i may encounter any problems or offer any advice/code?

Cheers

**royUK** · 09-23-2011, 02:21 AM

I wouldn't send anything relying on VBA for thispurpose. Simply create a form on worksheet, send that out to be filled in. When it is returned use code in the master workbook to import the replies to the results database

**Blake 7** · 09-23-2011, 03:23 AM

Hi Roy - thanks for taking the time to respond. N

Never done this before so just to clarify. ....

Create a form
Send it out to say 20 people
20 people return it to me

This is where i'm stuck - how do I collate the data from 20 seperate spreadsheets? can you descibe the Mater Workbook?

Sorry to bother you, cheers mate

**royUK** · 09-23-2011, 04:56 AM

Set up a Table with a column for each answer then you can write code to copy the answers to the table. I'm at work now but if you create a dummy form then I'll look at it later