Duplicating a form in Excel?

[Toolman55]

Hello all;

I was wondering if anyone had any tips, tricks, or techniques to re-creating a form in Excel. My purpose is two fold--1) "fill out" the form in Excel, and have it print on the real forms that are loaded in my printer.
2) be able to use VBA to take info from the Excel "form" and put it in a database for use later.

Other than trial and error to get the fields line up, any one have any thoughts. Even software suggestions?

Thanks,
Don

[ProfessorU]

What about scanning the form, dropping it into word and then putting a table over the image? That still requires some trial and error but not quite as much.

[Tuttle]

Excel is probably the worst choice for this; unlike Word and Access, you don't get rulers to work with. Access also has the advantage of being the database.

It can be done with Excel though; at work we have a spreadsheet with VBA macros that create and populate text boxes on the spreadsheet. When the layout of the printed forms changes we just have to tweak the numbers instead of dragging things around. It's still not a great system though.