Not sure about forms in the sheet, but userforms act like normal forms in vb/access.
Code:
txtControlName.text = activesheet.cells(lngRowNumber,lngColumnNumber)
The .text may be optional.
The row and column numbers start at 1.

Depending how you scroll up and down through the sheets records, depends on whether this method is what you are looking for.