Data Form

[Kaye]

I'd like to have the Data Form appear automatically on opening a
spreadsheet, rather than going through Data | Entry from the toolbar.

This is to be used for data entry into a simple club membership list.

Can this be done, and if so how?

Tks, Kaye

 

[Bob Phillips]

Private Sub Workbook_Open()
With Worksheets("Sheet1")
.Select
.Columns("A:E").Select
.ShowDataForm
End With
End Sub


This is workbook event code.
To input this code, right click on the Excel icon on the worksheet
(or next to the File menu if you maximise your workbooks),
select View Code from the menu, and paste the code

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Kaye]

Thanks so much Bob,

Regards, Kaye

 

[Kaye]

Hi Bob,

For some reason, the macro falls over at line
..ShowDataForm
with it highlighted yellow.

This is the same problem that I encountered when trying to record the
macro to show the Data Form.

I'm using Excel 2002.

Any clues on why it's falling over?

Regards,
Kaye

 

[Bob Phillips]

Not really, it worked fine in my test. What error is it showing?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Kaye]

Hi Bob,

Jeez, I somehow got it to work just a minute ago.

I think the problem was with having blank cols A and B to the left of
my list, and a blank row at the top with the list "headers" in row 2.

Thank you for that rapid responce!

Regards, Kaye