Retrieve data from excel in userform to edit

**Daantje71** · 07-02-2013, 02:15 PM

dear all,

is there a way to retreive my data from excel (put in excel by using userform) into my userform to adapt & edit my data - and then put the edit data back in the correct row.. ? I've been looking at a lot of threads but found no good answer yet

act.xlsm

greetings Daantje71

**Kenneth Hobson** · 07-02-2013, 03:02 PM

Welcome to the forum!

I started this sort of project based on John Walkenbach's example:
http://spreadsheetpage.com/index.php..._without_word/

My attached file includes editing data based on three methods, one of which is the Userform method. It also includes code to do a mailmerge.

Being as this is your first post, you may have lots of questions. Examine the code to learn how it was done. It is fairly involved so it will take some time to learn.