How to resize Data, form with current wksht information
 

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.

How to resize Data, form with current wksht information
 

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.