+ Reply to Thread
Results 1 to 2 of 2

Resetting drop down selection

  1. #1
    Registered User
    Join Date
    09-20-2014
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    16

    Question Resetting drop down selection

    I have a drop down box (created using data validation). I have a macro that takes me to a sheet with this drop down box on.
    If I make a selection from the drop down box and move away from that sheet, then run the macro to take me back to that sheet, the drop down box still shows my previous selection. Instead, every time I go back to that sheet, I want the drop down box to display the top selection (which will be something like "make a selection") instead of my last chosen selection.

    Does anyone know how to do this?

    Thanks

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Resetting drop down selection

    Use the Worksheet_Activate event of that sheet to set the value of the cell to whatever text you want:
    Please Login or Register  to view this content.
    Remember what the dormouse said
    Feed your head

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Resetting a column of lists to a default selection
    By annapolisjay in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-30-2014, 01:38 PM
  2. [SOLVED] Newbie - Resetting Cell Values (Drop Down List)
    By thussain in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-24-2014, 06:22 AM
  3. resetting conditional drop down lists
    By kevinexcel in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 07-22-2010, 11:19 AM
  4. Resetting drop menu's
    By Dreekenkorin in forum Excel General
    Replies: 2
    Last Post: 11-01-2009, 07:39 PM
  5. Resetting Drop down lists
    By jamieb007 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-10-2009, 06:31 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1