Save excel userform

[gengilino]

Hello. I am New to VBA. Complete Novice, but have managed to create an excel Userform, whit fields such as Date, Name, Has the target been met?, What could be done to meet the target in the future?

I have managed to put a close box in, and linked it so that the userform closes and goes back to the original worksheet, and It also saves the whole workbook too, but, for love nor money, I can not make it save the userform. It just opens blank every time. I would Ideally like to make it save as a word document in a specific file on the system each time, and also save the userform on the excel file so that it can be accessed easily from the excel workbook.

The Word file would be good for easy formatting into a report format, and the Userform version would be useful for browsing and looking for ideas when filling out the next form.

To summarise:
- I want to save userform data as word file
- I want the original userform to be saved in excel.

Any help would be greatly appreciated.

Kind Regards

Gengilino

[royUK]

You cannot save a userform like that.

The data has to be saved to a worksheet. You can re-populate it from this saved data.

I can't see why you need a Word document, it could all be done in Excel

[gengilino]

Hi. Thanks for your reply

Word would be ideal, but Im happy to save it to excel, at the moment I cant find out how to do anything with it.

If I can just keep a record of what has been written in the userform in any format at all it would be a great help.

Kind Regards

Gengilino

[royUK]

Have a look at the DataBase Form example

[gengilino]

Hi. I'm afraid I'm on a work computer and cant download and unzip files.

Is it really this difficult to just save a userform? What is the point in userforms is the information you input can not be saved.

From the small amount of coding I have done I thought it would be something as simle as

UserForm.Save
Then some coding that specifies where the userform would be saved to.

Please help. Im sure it must be really really simple.

[gengilino]

Ive just found this bit of code that looks like it should work:

Please Login or Register  to view this content.

In theory this should save the value from a textbox to a cell. But it doesn't.

I have added the code to the macro for the individual text box, I have added the code to the save 'n' close box, I have reversed the code to;

Please Login or Register  to view this content.

None of them work.

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I've added them this time. There's nothing wron with the code, but where have you put it?