Show Data Form
 

I am trying to write a short and simple macro that will bring up the data
form so that the user can search for records.

When I use:

ActiveSheet.ShowDataForm

The data form that comes up only has the title box.... not the fields for
the other 10 categories as well. But when I click on Data and Forms myself
the data form comes up with all the fields.

Why doesn't the macro bring up the full data form?

Show Data Form
 

Christine,
Try this. If your userform is named "DataForm"
DataForm.Show

Rick



"Christine" wrote in message
...
I am trying to write a short and simple macro that will bring up the data
form so that the user can search for records.

When I use:

ActiveSheet.ShowDataForm

The data form that comes up only has the title box.... not the fields for
the other 10 categories as well. But when I click on Data and Forms myself
the data form comes up with all the fields.

Why doesn't the macro bring up the full data form?

Show Data Form
 

It is not a custom user form, I am trying to bring up the standard data form
in Excel for those users who aren't familiar with the tools in Excel.

Normally when you have a list in your spreadsheet is views by clicking on
DATA and then FORMS.

"Rick Hansen" wrote:

Christine,
Try this. If your userform is named "DataForm"
DataForm.Show

Rick



"Christine" wrote in message
...
I am trying to write a short and simple macro that will bring up the data
form so that the user can search for records.

When I use:

ActiveSheet.ShowDataForm

The data form that comes up only has the title box.... not the fields for
the other 10 categories as well. But when I click on Data and Forms myself
the data form comes up with all the fields.

Why doesn't the macro bring up the full data form?

Show Data Form
 

Assume your data is in B9:Z100

Range("B9:Z100").Name = "Database"
ActiveSheet.ShowDataForm


sometimes naming your data range "Database" will help.

--
Regards,
Tom Ogilvy



"Christine" wrote in message
...
It is not a custom user form, I am trying to bring up the standard data
form
in Excel for those users who aren't familiar with the tools in Excel.

Normally when you have a list in your spreadsheet is views by clicking on
DATA and then FORMS.

"Rick Hansen" wrote:

Christine,
Try this. If your userform is named "DataForm"
DataForm.Show

Rick



"Christine" wrote in message
...
I am trying to write a short and simple macro that will bring up the
data
form so that the user can search for records.

When I use:

ActiveSheet.ShowDataForm

The data form that comes up only has the title box.... not the fields
for
the other 10 categories as well. But when I click on Data and Forms
myself
the data form comes up with all the fields.

Why doesn't the macro bring up the full data form?