Saving data in form before sending it to email address

[hsahota1]

Hi Guys,

I am very new to this forum - and really need some help.

I have created a form in vb in excel. Basically, we wanted to send the form to our services aro9und the country and ask them to enter their details - i.e. name address, service information (I created the form with combo boxes, tick boxes as well as text boxes in order for ppl to fill it in). The idea was supposed to be that once the data was entered the service could email this back to us.

I have managed to create the form and then also have found the code for the service to click submit and email the form back...

PROBLEM = the data doesn't save in the form when it is entered. I think, after doing some research that I haven't told this data to go to the excel spreadsheet behind it. NO ONE seems to be able to help me...

Can someone help? Tell me what I need to do...???? Please I will be so grateful. Please, please please?

Thank you guys in advance for taking the time to read this...

[davesexcel]

Who is NO ONE ?

Some action on the UserForm should Transfer the information to the worksheet.

You have to make it happen though.

Something like...

Please Login or Register  to view this content.