Read/Write Userform to variable range of cells

[sivart9876]

I really and truly scoured the internet for an answer to this but have been unsuccessful thus far. Hope I am not being redundant but....

I am essential making a simple database and I need a userform to make it more user friendly. I would like to create a userform that can reference - and cycle through - a (variable) set of rows/records on a sheet enclosed in the .xls file. I would also like to read and write to these cells on said sheet. Is there a way to do this without having to click a button to edit/submit data from a userform? If you could please include code about how to do this with textbox, comboboxes, listboxes, and checkboxes, I would be utterly grateful.

Thanks in advance,
Travis

[BrianMH]

This may be helpful.

http://spreadsheets.about.com/od/datamanagementinexcel/ss/090717_data_form.htm

[sivart9876]

Yeah, that is almost what I want. The only thing is I want to make a custom userform, you know the 1 that you use in vba. I just need to make 1 with the same functionality.

[Kenneth Hobs]

You are better off just doing it in Access.

[Kenneth Hobs]

I combined that sort of thing with a mail merge to MSWord. I used some data and parts from John Walkenbach's ElephantsRus example.

http://www.vbaexpress.com/forum/showthread.php?t=36057