VBA RRS feed

All replies

  • Re:  Protecting Data Validation

    Reponse removed.


    • Edited by James Cone Friday, June 26, 2015 5:38 PM question was removed
    Thursday, June 25, 2015 11:07 PM
  • Hi Alli,

    Would you inform us the range that should be validated? I'll try to make sample VBA.

       a sample code:  the range for validation is B2:D12 
    Private Sub Worksheet_Change(ByVal Target As Range)
        If Intersect(Target, Range("B2:D12")) Is Nothing Then
            Exit Sub
            MsgBox ("Validate value: 12 digits + 1 space + 4 digits ")
        End If
    End Sub
    • Edited by Ashidacchi Thursday, June 25, 2015 11:40 PM
    Thursday, June 25, 2015 11:21 PM
  • Hi Alli,

    I've made a sample Excel file. Cliick here for download
    [Note] in this sample, range for validation is "B2:D12". Please change it according your need.

    Best regard,
    Friday, June 26, 2015 12:39 AM
  • The range is N2:N1000.

    I tried putting my desired range in, and when I typed an entry that should work I still got the message box.

    Friday, June 26, 2015 12:45 PM
  • I'm sorry, I cannot understand what you mentioned. Please make it concrete. What's wrong?
    Friday, June 26, 2015 3:09 PM
  • This link suggests what looks to be a reasonable solution


    It suggests creating an event that will 'undo' any worksheet change event that causes an area with data validation to be overwritten.

    Friday, June 26, 2015 4:08 PM
  • Hi Alli,

    You removed the question, does your issue be solved? Please mark the reply as answer, which is the solution of that question.



    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, July 10, 2015 1:24 AM