Data Entry Form not showing drop down list

Jasesair

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

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,682
Office Version
  1. 365
Platform
  1. Windows
How are you setting the data validation?
 

Jasesair

Board Regular
Joined
Apr 8, 2015
Messages
221
Office Version
  1. 2016
How are you setting the data validation?
Setting it as a List, and checking both the 'ignore blanks' and 'in-cell dropdown'. The source is referring to my created list on a separate sheet.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,682
Office Version
  1. 365
Platform
  1. Windows
What do you have in the Source box?
 

Jasesair

Board Regular
Joined
Apr 8, 2015
Messages
221
Office Version
  1. 2016

ADVERTISEMENT

=Sheet2!$A$1:$A$15 ...which is referencing my list.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,682
Office Version
  1. 365
Platform
  1. Windows
Ok, goto file, options, advanced, scroll down to "Display options for this workbook" & make sure that "For objects show" you have All checked.
 

Jasesair

Board Regular
Joined
Apr 8, 2015
Messages
221
Office Version
  1. 2016

ADVERTISEMENT

Yep, that is checked as All.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,682
Office Version
  1. 365
Platform
  1. Windows
Have you ever deleted shapes & or drawing objects from the sheet with a macro?
Also is the DV in an area that has been frozen with freeze panes?
 

Jasesair

Board Regular
Joined
Apr 8, 2015
Messages
221
Office Version
  1. 2016
Have you ever deleted shapes & or drawing objects from the sheet with a macro?
Also is the DV in an area that has been frozen with freeze panes?
No, I've only just created this workbook simple to experience the Data Entry Form. There is no other information in the workbook at all.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,682
Office Version
  1. 365
Platform
  1. Windows
In that case I don't know. With settings like these
1603228489361.png

You should get the drop down when you select the cell
1603228527259.png

1603228544106.png
 

Watch MrExcel Video

Forum statistics

Threads
1,127,853
Messages
5,627,259
Members
416,236
Latest member
Lynchbox

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