Customising the standard Excel (Data) Form

%3CLINGO-SUB%20id%3D%22lingo-sub-1143755%22%20slang%3D%22en-US%22%3ECustomising%20the%20standard%20Excel%20(Data)%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1143755%22%20slang%3D%22en-US%22%3E%3CP%3EI%20asked%20MS%20Support%20for%20an%20email%20address%20to%20ask%20MS%20direct%2C%20but%20they%20would%20only%20refer%20me%20to%20this%20community!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EDuring%20my%20working%20life%20I%20became%20quite%20proficient%20in%20the%20business%20use%20of%20Excel%20-%20I%20am%20now%20doing%20some%20voluntary%20work%20for%20a%20local%20end-of-life%20charity%20and%20need%20to%20create%20a%20data%20entry%20form%20-%20the%20standard%20Excel%20(Data)%20Form%20gives%20me%20most%20of%20what%20I%20want%20in%20terms%20of%20functionality%2C%20but%20I%20do%20need%20to%20do%20some%20customisation%20which%20I%20know%20is%20not%20possible.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20know%20I%20could%20build%20a%20VBA%20UserForm%20(but%20I%E2%80%99m%20a%20novice%20as%20far%20as%20VBA%20is%20concerned)%20-%20but%20I%20was%20wondering%20whether%20MS%20would%20share%20the%20code%20(which%20I%20assume%20is%20VBA%3F)%20behind%20each%20of%20the%26nbsp%3Btextboxes%2C%20command%20buttons%2C%20etc%20on%20the%20standard%20form%20that%20I%20could%20adapt%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EFor%20example%20(but%20not%20exhaustive)%20...%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E-%20I%20don't%20want%20to%20display%20all%20columns%20in%20my%20table%20(some%20are%20calculated%20and%20some%20are%20%22hidden%22%20as%20far%20as%20regular%20users%20are%20concerned)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E-%20I%20want%20to%20pre-populate%20some%20of%20the%20fields%20when%20Add%20is%20chosen%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E-%20I%20don't%20want%20regular%20users%20having%20a%20Delete%20Command%20Button%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E-%20etc%2C%20etc%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIf%20it's%20not%20possible%20to%20have%20the%20code%20that%20MS%20have%20used%2C%20can%20anyone%20help%20me%20by%20pointing%20to%20somewhere%20where%20I%20can%20find%20at%20least%20most%20of%20what%20I%20need%20to%20give%20me%20a%20starter%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EMany%20thanks%20in%20advance%20...%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1143755%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1149520%22%20slang%3D%22en-US%22%3ERe%3A%20Customising%20the%20standard%20Excel%20(Data)%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1149520%22%20slang%3D%22en-US%22%3EI%20hope%20you%20will%20find%20what%20you%20are%20looking%20for%20because%20I%20was%20looking%20for%20the%20same%20thing%20before%20and%20couldn't%20find%20it.%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20not%20sure%20having%20the%20code%20at%20hand%20would%20solve%20your%20issue%20if%20you%20don't%20have%20any%20experience%20with%20VBA.%20If%20I%20was%20you%20I%20would%20sign%20up%20for%20a%20udemy%20training%2C%20this%20Is%20how%20I%20learned%20how%20to%20do%20it%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.udemy.com%2Fcourses%2Fsearch%2F%3Fsrc%3Dukw%26amp%3Bq%3Duser%2520form%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.udemy.com%2Fcourses%2Fsearch%2F%3Fsrc%3Dukw%26amp%3Bq%3Duser%2520form%3C%2FA%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1149560%22%20slang%3D%22en-US%22%3ERe%3A%20Customising%20the%20standard%20Excel%20(Data)%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1149560%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F422482%22%20target%3D%22_blank%22%3E%40PascalKTeam%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20absence%20of%20even%20an%20acknowledgement%20from%20MS%2C%26nbsp%3BI%20have%20built%20a%20UserForm%20that%20does%20everything%20(and%20more)%20that%20the%20standard%20Excel%20form%20...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1149576%22%20slang%3D%22en-US%22%3ERe%3A%20Customising%20the%20standard%20Excel%20(Data)%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1149576%22%20slang%3D%22en-US%22%3EFantastic%20to%20hear%20that%20it%20worked%20out!%3C%2FLINGO-BODY%3E
New Contributor

I asked MS Support for an email address to ask MS direct, but they would only refer me to this community!

 

During my working life I became quite proficient in the business use of Excel - I am now doing some voluntary work for a local end-of-life charity and need to create a data entry form - the standard Excel (Data) Form gives me most of what I want in terms of functionality, but I do need to do some customisation which I know is not possible.

 

I know I could build a VBA UserForm (but I’m a novice as far as VBA is concerned) - but I was wondering whether MS would share the code (which I assume is VBA?) behind each of the textboxes, command buttons, etc on the standard form that I could adapt?

 

For example (but not exhaustive) ...

 

- I don't want to display all columns in my table (some are calculated and some are "hidden" as far as regular users are concerned)

- I want to pre-populate some of the fields when Add is chosen

- I don't want regular users having a Delete Command Button

- etc, etc

 

If it's not possible to have the code that MS have used, can anyone help me by pointing to somewhere where I can find at least most of what I need to give me a starter?

 

Many thanks in advance ...

3 Replies
I hope you will find what you are looking for because I was looking for the same thing before and couldn't find it.

I'm not sure having the code at hand would solve your issue if you don't have any experience with VBA. If I was you I would sign up for a udemy training, this Is how I learned how to do it: https://www.udemy.com/courses/search/?src=ukw&q=user%20form

@PascalKTeam 

 

In the absence of even an acknowledgement from MS, I have built a UserForm that does everything (and more) that the standard Excel form ...

Fantastic to hear that it worked out!