Data Entry Form not showing drop down list

Jasesair

Board Regular
Joined
Apr 8, 2015
Messages
222
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
222
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

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,682
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
222
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,682
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,127,861
Messages
5,627,315
Members
416,239
Latest member
Counselor85027

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