Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I resize a check box form object in Excel? | Excel Discussion (Misc queries) | |||
How do I put my information form Excel into a Word Merge Form? | Excel Discussion (Misc queries) | |||
Linking information form one worksheet to another | Excel Discussion (Misc queries) | |||
How to resize Data Form dialog window? | Excel Worksheet Functions | |||
Can't move from one cell and/or enter any data, or exit wksht... | Excel Discussion (Misc queries) |