View Single Post
 
Old 12-09-2014, 08:40 AM
Phil H Phil H is offline Windows XP Office 2003
Advanced Beginner
 
Join Date: Jun 2010
Posts: 81
Phil H is on a distinguished road
Default The Best Solution

Here is the best solution - using a combo box (Again, from contextures http://www.contextures.com/xlDataVal14.html ). This approach puts a combo box (properties can be changed to suit) in any selected DV cell, and with additional code at the bottom, will dismiss the combo box when the next cell is selected. Remember to change the combobox name in the code.
Reply With Quote