Data Entry Form not showing drop down list

[Jasesair]

I was creating a simple Data Entry Form and, through Data Validation, attempted to create a drop down list for one of the fields. Whilst the data validation works (if the field entry isn't spelled correctly, it won't allow the entry), no such drop down list actually appears for the end user.

Any assistance would be fantastic.

 

[Jasesair]

Yes, that's definitely happening. There is no dropdown when I click into the name field when using the form.

 

[Fluff]

Ok, you are not talking about the Data validation not working, you are talking about the data form, they are two totally different things.

I have never used the inbuilt form, as I always create my own, but I'm pretty sure the the inbuilt form does not do drop downs.

 

[Jasesair]

Apologies, I wasn't attempting to be misleading - the thread is referring to the Data Entry Form.

I like the how the Data Entry Form functions (to enter and edit entries etc). Is there a different option I can use to do similar, where some of the fields can have dropdowns? Any help would be very much appreciated.

 

[Fluff]

Not that I'm aware of with the inbuilt data form, however you can create your own userform.

How to Create Excel UserForm for Data Entry

See how to create an Excel UserForm for data entry, with text boxes and buttons. Follow step-by-step videos, detailed notes with screen shots, free Excel workbook

www.contextures.com

VBA UserForm - A Guide for Everyone - Excel Macro Mastery

Learn how to quickly and easily add an Excel VBA UserForm to your project. See how to open, close, read from etc. Tons of useful code examples.

excelmacromastery.com