Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-20-2021, 05:11 PM
MaineLady MaineLady is offline Using a dropdown list Windows 7 32bit Using a dropdown list Office 2013
Advanced Beginner
Using a dropdown list
 
Join Date: Sep 2014
Posts: 51
MaineLady is on a distinguished road
Default Using a dropdown list

I want to use a dropdown list for repetitive data entered in some cells, but I also want to be able to make entries that are not on the list. How do I do that?

Thank you...


Janice
Reply With Quote
  #2  
Old 04-20-2021, 11:15 PM
ArviLaanemets ArviLaanemets is offline Using a dropdown list Windows 8 Using a dropdown list Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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
  #3  
Old 04-21-2021, 03:29 AM
MaineLady MaineLady is offline Using a dropdown list Windows 7 32bit Using a dropdown list Office 2013
Advanced Beginner
Using a dropdown list
 
Join Date: Sep 2014
Posts: 51
MaineLady is on a distinguished road
Default

Thank you so much... Problem solved
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selection of a dropdown creates another dropdown wih the list krishnamurthy.ka2810 Word VBA 1 04-26-2018 11:44 PM
Dropdown list with values pgwatt Excel 6 10-24-2016 03:48 PM
Dropdown list for Images? JakeLRL Word VBA 3 04-07-2016 02:57 AM
Help!! Dropdown List christo16 Word 1 06-29-2015 05:18 AM
Dropdown list, Macro shield5 Excel Programming 7 10-27-2013 01:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:25 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft