Data Entry Form not showing drop down list

Jasesair

Board Regular
Joined
Apr 8, 2015
Messages
219
Office Version
  1. 2016
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

Board Regular
Joined
Apr 8, 2015
Messages
219
Office Version
  1. 2016
Yes, that's definitely happening. There is no dropdown when I click into the name field when using the form.
 

Attachments

  • Form.png
    Form.png
    63.4 KB · Views: 5

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,231
Office Version
  1. 365
Platform
  1. Windows
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

Board Regular
Joined
Apr 8, 2015
Messages
219
Office Version
  1. 2016
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,231
Office Version
  1. 365
Platform
  1. Windows
Not that I'm aware of with the inbuilt data form, however you can create your own userform.
 

Watch MrExcel Video

Forum statistics

Threads
1,126,953
Messages
5,621,805
Members
415,857
Latest member
braunReivn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top