+ Reply to Thread
Results 1 to 3 of 3

Data validation defaults for multiple dropdowns

  1. #1
    Registered User
    Join Date
    06-09-2014
    Posts
    3

    Data validation defaults for multiple dropdowns

    I am very new to this and trying to put together a form with multiple dropdowns, but want the second group of dropdowns to default to blank if the first cell is changed. I hope that made sense...

    Capture.PNG

    So if A26 changes I want B26 to turn blank
    same for A27 and B27 and so on through A48 and B48.
    And then again for C26 and D26 through C48 and D48.

    I input this code and it worked perfectly for A26 and B26, but I can't figure out how to include the rest of the cells.

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target = Range("A26") Then
    Target.Offset(0, 1).Value = ""
    End If

    End Sub

    Thanks!

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Data validation defaults for multiple dropdowns

    Try this...

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    06-09-2014
    Posts
    3

    Re: Data validation defaults for multiple dropdowns

    YES! Thank you!!!

+ 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. [SOLVED] Dynamic Data Validation Dropdowns Problem
    By Cavinaar in forum Excel General
    Replies: 2
    Last Post: 12-17-2013, 08:44 AM
  2. How to set cell to certain value depending on two data validation dropdowns
    By StJohnny22 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 04-02-2013, 02:32 AM
  3. Replies: 1
    Last Post: 12-26-2012, 11:54 PM
  4. How To Program for Data Validation With If Functions and Defaults
    By Freerider15 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-13-2011, 09:35 PM
  5. Data Validation Dropdowns and Change Events
    By NSTAR in forum Excel General
    Replies: 1
    Last Post: 08-16-2009, 06:10 AM

Tags for this Thread

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