Hi everybody. Well, I've spent the requisite 4+ hours looking in
manuals, searching the Internet and this group, and I'm totally
confused about how Excel works with regard to "databases" and forms
and macros. I have moderate understanding of spreadsheets (e.g.
lookup and formulas), but what's got me lost is defining areas and
forms and getting the macro (button) to bring up a form. I'm using
Excel 2003.

So I'll start with some really basic stuff. In a spreadsheet, I've
got the following 4column x 2row entries:

NAME CITY PRICE DATE
x y 6 7

I've also done the following: Selected the first two rows and columns
(2x2) and then invoked Insert/Name/Define, and entered "First2". Then
I selected the other two rows and columns (2x2) and invoke Insert/Name/
Define, and entered "Second2".

Hi
Your macro works fine if you have set up a form on the active sheet, ie. if
your form is on sheet1 activate that sheet before showing the dataform

Sub LoadDataForm ()
Sheets("Sheet1").Activate ' Change Sheet1 to suit.
ActiveSheet.ShowDataForm
End Sub

Hope that helps.

Regards,
Per

"mpysr" gmail.com> skrev i meddelelsen
news:685d7375-41dc-4db5-b85a-770f6ccfd310@l17g2000pri.googlegroups.com...