Closed Thread
Results 1 to 2 of 2

Setting data validation alerts to off to selected range in code

  1. #1
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Houston, TX
    MS-Off Ver
    office 365
    Posts
    647

    Setting data validation alerts to off to selected range in code

    How can I change the the data validation on the newly selected range in this code without resetting the other information in the data validation. I want when you select your range to change the format in the macro for it to also set the validation error alerts off .

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,475

    Re: Setting data validation alerts to off to selected range in code

    Continue here, please: https://www.excelforum.com/excel-pro...t-working.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help with setting up custom Reddit alerts
    By Tarian in forum Excel General
    Replies: 2
    Last Post: 12-18-2016, 02:23 PM
  2. [SOLVED] Setting the range as only those cells selected/ highlighted
    By strud in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-18-2013, 06:45 AM
  3. Assistance in setting up some roster alerts.
    By Jabbitar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-09-2012, 04:35 AM
  4. Setting validation rule using code
    By stoney1977 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2007, 07:47 PM
  5. Setting up a validation of data listbox to provide the unique items within a range
    By jedale@gmail.com in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-30-2006, 04:10 AM
  6. Data validation - error alerts
    By ledgreg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2006, 04:55 PM
  7. data validation list selected from a range
    By Native in forum Excel General
    Replies: 11
    Last Post: 01-19-2006, 09:15 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