Hi,

This is an automatically generated form, you have no control over its size.
To do that you would need to write VBA and create a user form.

You can make the form longer by adding dummy columns to your data area - not
a very satisfactory solution!

You can make the form wider by create one long title - for example adding a
lot of spaces after the title Name. This is also a pretty ugly approach.


--
Cheers,
Shane Devenshire


"RennieMay" wrote:

I am trying to learn how to resize the form box that appears when you select
Data, Select Form. This create an automate form that uses the current
worksheet headers, showing only 1 row at a time for you to fill in.