Creating a pull down list

montanaaggie

Board Regular
Joined
Nov 11, 2005
Messages
110
I am having a problem with allowing a cell to use free hand writing as well as the choices. I create a list by highlight the specific cell. Going to Validation. Selecting List. Selecting Source.

How can I select the source and allow for someone to write in a different answer? Is this possible?
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,870
Hi montanaaggie

Try unchecking the Show Error Alert.

HTH
PGC
 

Watch MrExcel Video

Forum statistics

Threads
1,111,910
Messages
5,541,541
Members
410,547
Latest member
htran4
Top