ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   data entry form Excel (https://www.excelbanter.com/excel-discussion-misc-queries/47081-data-entry-form-excel.html)

Aart Dijkzeul

data entry form Excel
 
The data entry fields of the standard data entry form in Excel are too small
and therefore not adequate for me.
Is there a way to enlarge the fields in this standard form; if not is there
a way to create my own data entry form in a simple way for example by using a
wizard programm


Debra Dalgleish

You can't widen the text boxes in the data entry form. You could try
John Walkenbach's Enhanced Data Form. It's a free add-in that has
slightly wider boxes, and allows combo boxes, and unlimited fields.

http://j-walk.com/ss/dataform/index.htm

Or, you could create your own form. There are instructions he

http://www.contextures.com/xlUserForm01.html

Aart Dijkzeul wrote:
The data entry fields of the standard data entry form in Excel are too small
and therefore not adequate for me.
Is there a way to enlarge the fields in this standard form; if not is there
a way to create my own data entry form in a simple way for example by using a
wizard programm



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 04:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com