Sorry m8, I had almost given up hope.

It is a DataForm called up from a macro using this VBA
code:

VBA code for OpenDataForm

Sub OpenDataForm()

Dim ws As Worksheet
Set ws = Worksheets("Record")

SendKeys "%w"
ws.Range("Database").Worksheet.ShowDataForm
End Sub


Where "Database" is a named range using a dynamic range
of cells. The user will input 8 lines of information
which will be entered into the next empty row in the
range.

Scroll bars are turned off, as are Sheet Tabs, and column
and row headers, and when the user saves the spreadsheet
prior to exiting, (called from a macro), the spreadsheet
maximises, so that, when it is opened by another user, it
opens full screen. That way, the GUI dimensions remain
static.

So, could I use your code for a DataForm instead of a
UserForm?

If so, can you explain your code? My VBA isn't good.

Where do I enter the values?

Many thanks for replying.

Mark Flaxman