Find drop down list entry with keystrokes

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Find drop down list entry with keystrokes

06-09-2018, 06:10 AM

NoSparks

Windows 7 64bit Find drop down list entry with keystrokes

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

If you create a named range =Table1[Company]
and use that named range for your data validation
then this will do what you're wanting.

Tags

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Drop down box list based on response to another drop down box	Phideaux	Excel	16	04-13-2018 03:07 AM
Win 8.1 won't allow entry from drop down list in Outlook	nphutchnson	Outlook	0	10-18-2014 10:46 AM
Trying to update a table cell with a value based on a drop down box entry	mkasem	Word VBA	2	09-29-2013 08:36 PM
Drop-down Populated with text entry	ReviTULize	Word VBA	14	02-21-2013 07:06 PM
autocorrect: cannot find corresponding entry that produces particular behavior	beej	Outlook	1	11-02-2012 12:19 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:57 AM.