Can the Excel forms be changed or customised?
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Forms
0
Answers
0
Selected Answer
You don't specify what you mean by Excel "forms" but as a rule of thumb almost anything in Excel can be customised. The most likely subject of your question should be the VB User Form. That is a form created by the user, entirely to the user's specs. In order to create and modify it some knowledge of VBA is required.
The Data Entry Form to which you referred, as you explained in the Discussion below, can't be customized in itself. Instead it takes all requirements from the table to which it refers. Add a column to the table and the form wil have an extra field named after the column. If you increase the size of the column the data entry field in the form will grow accordingly.
Discussion
Data Forms is what I was refering too.It opens when I use the Form button. I was able to make a form by creating a table.
The input form is too small. What I was wanting to do is "customize" this form to make it easier to enter data in.
The input form is too small. What I was wanting to do is "customize" this form to make it easier to enter data in.
jrlead (rep: 2) Apr 21, '20 at 12:44 am
I should have thought of that lol: Now I have expanded my answer to cover that form. Did I answer your question?
Variatus (rep: 4889) Apr 21, '20 at 4:59 am