+ Reply to Thread
Results 1 to 3 of 3

Data Validation

  1. #1
    Registered User
    Join Date
    10-27-2011
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    88

    Data Validation

    I have the following macro which transfers values from a sheet ("BM1") and inserts them into another sheet ("Banking")

    It then calls another macro and moves back to the original sheet.

    I have a potential issue as I have a Data Validation rule set up on the "Banking" sheet to make sure only certain values can be entered, but when the values are inserted via this method the Data Validation is ignored.

    How can I ensure the Data Validation is adhered to with VBA?

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    5,124

    Re: Data Validation


    As Data Validation is for manual input only, you can use an advanced filter or any other way respecting the rules

  3. #3
    Registered User
    Join Date
    10-27-2011
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    88

    Re: Data Validation

    Thanks for your response, can you advise how I might check via VBA that the value is correct, it refers to a dynamic list:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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. Replies: 1
    Last Post: 01-14-2018, 11:04 AM
  2. Multi-select from data validation isn't working with auto-assigning data validation
    By iPenguin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2017, 12:37 PM
  3. Replies: 3
    Last Post: 06-04-2015, 02:27 PM
  4. [SOLVED] Data Validation: How to clear/delete the content of the cell and not Data Validation List?
    By lukelucky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-07-2015, 09:42 AM
  5. Replies: 4
    Last Post: 07-03-2014, 02:37 AM
  6. Replies: 4
    Last Post: 12-19-2013, 10:44 AM
  7. Using Defined Names with Data Validation Depend and Data Validation Multi Select
    By Vinnie Chan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-01-2012, 05:36 PM

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