Hi, not an approach I would recommend but you can have an Excel spreadsheet embedded in a form. Not sure which versions have these objects but I have XL2002 which has this. With the form is design view open up the Control toolbox and then right click a blank area of the toolbox and select Additional Controls. Scroll down until you see Microsoft Office Spreadsheet 10.0 and put an x in the box and this control will be added to the control toolbox.

Ive never used this control but like all controls on a Userform it will not 'store' the information so when the User has finished entering data you will need to save to a sheet.

As a suggestion you could simply have an entry sheet with drop-downs etc that the user inputs info into and then clicks a button which populates it to the correct sheet/range. Like a front-end if you like. Call me old fashioned but an embedded worksheet on a form doesnt sit right with me.