I have created a user form in vba that someone would fill in various text boxes.
What i now want is the info to be summarised in excel.
The userform is held in sheet 1, so the idea is the user would input the information in the text boxes and then click the command button and the text boxes information would be copied to indiviual cells i.e textbox1 to a1 on sheet 1.
I have tried by running a macro in excel to see the vb code but that does not work for a vba form.
If anyone needs the file let me know and i will attach it