The drop-down arrow for a validation list disappears when you select another cell. This technique shows you how to create a fake drop-down icon that will mimic the real arrow. Download the sample file at the link above.
Bill Jelen’s solution in Mr Excel Podcast 1816 –
Subscribe to my free email newsletter.