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