Show Data Form

[Guest]

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?

 

[Rick Hansen]

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

Rick

 

[Guest]

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.

 

[Tom Ogilvy]

Assume your data is in B9:Z100

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


sometimes naming your data range "Database" will help.