I have a spreadsheet that contains four separate sheets, with each sheet
having in excess of 29 fields. Rather than the user inputing information
into a field, and then pressing TAB to move to the next field, and so on, I
am attempting to utilise the Date | Form option. My hope was to display an
input form listing all fields, so that the user could simply enter / view
records in this manner, rather than using the sheet. However, all four
sheets within the spreadsheet, contain different headings.

So, my question is as follows:

Is it possible, via a macro or VB code, to display a form listing the sheets
fields, whenever the focus changes to the form.

i.e. When sheet 1 is displayed, show a data entry form for entering the
information that is contained on Sheet one only. Then, if the user changes
to sheet 4, the data entry form would change to show only those fields on
sheet.


Hope someone can help.

Many thanks