+ Reply to Thread
Results 1 to 2 of 2

Reset Button to reset values to default in Drop List (created in Form Control)

  1. #1
    Registered User
    Join Date
    05-17-2019
    Location
    USA
    MS-Off Ver
    365
    Posts
    1

    Reset Button to reset values to default in Drop List (created in Form Control)

    Hi everybody, I got a worksheet in Microsoft excel 365 that contain , let's say 2 drop list. Those drop list were created using developer tab - insert List Box (Form Control). Now, I need to create a "RESET FORM" button that once is clicked, reset the fields of those 2 drop list to first value that are "- Select - ".
    I have been trying to assign a few codes to this button ( reading a lot of post in this forum) but none of them seem to works in my case. Also, I noticed that in others posts, answers assign a drop list to a cell, but in my case, mine drop list are like floating in my sheet, and have a range of value... i.e. I found this code:
    Sub ResetDataVal()
    Sheets("Sheet1").Range("B5").Value = "- Select -"
    End Sub

    First, one of my drop list is on top of B5 but like I say, is like floating, I can move it to anywhere...
    Second, I have assigned values from a range of cells (i.e $N$2:$N15$) and if I change B5 by my range... then when I click on button, all the range cells change to "- Select -"... and I don't want that

    What I need: is a RESET button (already created but not working) to my form that reset all my drop list from "number values" choose by user to "- Select -" when they click on RESET button.
    In other words, I don't have idea how to do it... any help please !
    Last edited by saguilera; 05-17-2019 at 11:11 AM.

  2. #2
    Registered User
    Join Date
    05-18-2019
    Location
    Alfreton
    MS-Off Ver
    365
    Posts
    1

    Re: Reset Button to reset values to default in Drop List (created in Form Control)

    Surely you need to have both lots of code run by the same function

+ 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. Button creation to reset values from drop down lists
    By BradleyAM in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-23-2017, 11:33 AM
  2. [SOLVED] I need to create a reset button that will reset rows containing a specific value
    By odin78 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 04-03-2016, 02:11 PM
  3. How to reset a drop down list with a button
    By mils in forum Excel General
    Replies: 2
    Last Post: 05-14-2015, 06:07 AM
  4. Macro to reset a drop down box to a default value?
    By ChrisF79 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-12-2013, 06:02 PM
  5. Drop Down List Titles As Default And Reset Button
    By travelersway in forum Excel General
    Replies: 0
    Last Post: 10-17-2005, 12:10 PM
  6. Establish Default Titles For Drop Windows And Reset Button
    By travelersway in forum Excel General
    Replies: 0
    Last Post: 10-17-2005, 07:31 AM
  7. Establish Default Titles For Drop Windows And Reset Button
    By travelersway in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 10-17-2005, 06:58 AM

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