I have created a workbook to score high school swim meets. In the header, I
have placed team names, date, etc.

I would like to write some code so that when I open the template, a form
pops up, and by completing the form, the header information will be filled in
automatically.
For example: Home team? Visiting eam? Date? Pool location?

Can someone help me with this, or suggest another way to accomplish the same
thing?

Thanks,
~ Horatio