Thread: [Solved] Using a dropdown list
View Single Post
 
Old 04-20-2021, 11:15 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

With dropdown list are you refer to Data Validation List? I.e.:

When you define Data Validation List for cell/range (from menu: Data>Data Validation, and then selecting List for Allow field and enter the comma separated list of allowed values, or a reference formula to range on same sheet or to a any Named Range, into Source field), on Error Alert tab you can use Style field to determine how the cell/range reacts on entries not in defined Data Validation List. The default value is Stop, which blocks any entries not in list. Selecting Warning or Information instead do allow such entries. For any of those selections, you can define what error message is displayed when a value not in list is entered, and a title for this error message.
Reply With Quote