+ Reply to Thread
Results 1 to 8 of 8

VBA - Insert Data Validation - List

  1. #1
    Registered User
    Join Date
    04-29-2015
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    82

    VBA - Insert Data Validation - List

    Hi,

    I'm looking to use the Count xlup vba code to insert the data validation onto the next line each time the macro is run. Is this even possible? Your help would be excellent.

    Kind Regards,
    Quasis
    Attached Files Attached Files
    Last edited by Quasis; 02-20-2017 at 06:33 AM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: VBA - Insert Data Validation - List

    Yes. But only you know what your DV looks like, which column you want to put it in, and which column can be used to determine the next row.

    Record a macro while you add your DV and then tweak it.

    Or convert your data to a Structured Table (Insert | Table)
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    04-29-2015
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    82

    Re: VBA - Insert Data Validation - List

    Hi TMS,

    I appreciate that, and I did record a macro but it kept throwing up errors. Essentially each time I run the macro I just want data validation to go into column B and the data can be found on sheet2 A1:A3. Is there any way you could assist with this?

    Kind Regards,
    James

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: VBA - Insert Data Validation - List

    Post a sample workbook with some typical data.

  5. #5
    Registered User
    Join Date
    04-29-2015
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    82

    Re: VBA - Insert Data Validation - List

    Hi TMS,

    I've now added the spread sheet, many thanks for your time.

    Kind Regards,
    James

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: VBA - Insert Data Validation - List

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    04-29-2015
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    82

    Re: VBA - Insert Data Validation - List

    Hi TMS,

    Many thanks, I've now marked it as solved. Your assistance was greatly appreciated, rep added.

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: VBA - Insert Data Validation - List

    You're welcome. Thanks for the rep.

+ 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: 3
    Last Post: 06-04-2015, 02:27 PM
  2. [SOLVED] Insert validation list with =INDIRECT in VBA
    By Crispy85 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-28-2014, 11:27 AM
  3. Replies: 4
    Last Post: 12-19-2013, 10:44 AM
  4. [SOLVED] How to insert a blank row between two rows of list names in data validation
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2013, 10:52 PM
  5. [SOLVED] Insert Validation List from another Sheet (Excel 2003)
    By Excelnoub in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-18-2012, 02:36 PM
  6. select mo/yr w/data validation list, insert celll entry into vba file reference code
    By ShannonHowell in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-10-2011, 04:07 AM
  7. Replies: 3
    Last Post: 04-11-2011, 05:52 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