Data Entry form (not a UserForm)

[Mel Smith]

I'm using a Data Entry form in one of my shared workbooks. The form is not a self-made Userform but a data entry form used within a table.

Is there a way that I can have this Data Entry Form open automatically when the workbook is opened to ensure that each user enters data via this form?

Thanks for your help.

Mel

 

[Fluff]

Do you mean the in-built data form?
If so you can try this in the workbook open event

    Sheets("Main").ShowDataForm

Just change the sheet name to suit

 

[Mel Smith]

Hello Fluff,

Yes the in-built data form. I used the code:
Private Sub Workbook_Open()
Sheets ("WCCC Squad").ShowDataForm
End Sub
but on opening the workbook I received a Worksheet class failed error message.

Mel

 

[Fluff]

Where does the data start?

 

[Mel Smith]

A4, which is the header row

Mel

 

[Fluff]

It appears that VBA doesn't like it if the header is not in row1 and I can't find any way round that.

 

[Mel Smith]

Hello Fluff,

Just as the notification of your post came through, I'd moved data out of rows 1-3 and moved my table up. After closing and re-opening, it worked a treat!

Many thanks, as always for your invaluable help.

Mel

 

[Fluff]

Glad to help & thanks for the feedback.