WillRn,

Yes, that is what I want to happen. Unfortunately, using your
instructions, I can't get it to work.

I can't find an entry for the "WorkBook _SheetActivate" event, nor can I
work out where to place any VBA code. In the VBA view, I have the
following tree:

VBAProject
Microsoft Excel Objects
Sheet 1
Sheet 2
ThisWorkbook

As I cannot find an entry specific to the event in question, I am unsure
as to where to place the event code. I have tried in so far in all
three locations under Microsoft Excel Objects, but so far, none have
worked.

Can you give me more info?

Many thanks & regards

Duncan

--
Newsgroups are like one big sandbox that all of us
UseNet kiddies play in with peace & harmony.

Spammers, Cross-Posters, and Lamers are the
people that pee in our big sandbox.

To e-mail, please remove NO_SPAM.
"WillRn" wrote in message
...
Iassume you are talking about the "Data Form" Option under the data
menu. If
you want the option to pop up each time the sheet is activated attach
this
code to the
"WorkBook _SheetActivate" Event:

ActiveSheet.ShowDataForm

And the Data Form will show each time a different sheet is selected.
Your
user will have to close the dialog box first however.

Hope this helps,

WillRn

"Duncan" wrote:

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