+ Reply to Thread
Results 1 to 2 of 2

When I add Validation VBA code, I cannot undo

Hybrid View

  1. #1
    Registered User
    Join Date
    04-13-2013
    Location
    Calgary, Canada
    MS-Off Ver
    Excel 2008
    Posts
    28

    When I add Validation VBA code, I cannot undo

    Dear Experts,

    Whenever I add the Validation code in my function, I cannot "Undo (CTRL +Z)" without changing worksheets. The worksheet changes to another one without really "selecting" the other one, if you know what I mean. It does "undo" but it changes worksheets. When I remove the code, it simply goes back the regular excel without flaws.

    With Sheets("Wine Stock").Range("B" & rowNumber)
        With .Validation
            .Delete
            .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
            xlBetween, Formula1:=xString
        End With
    End With
    What can I do???

    Thank you

  2. #2
    Registered User
    Join Date
    04-13-2013
    Location
    Calgary, Canada
    MS-Off Ver
    Excel 2008
    Posts
    28

    Re: When I add Validation VBA code, I cannot undo

    If I may also add, I am using a UDF to make the validation list. Does that have an impact on the Undo?
    ALSO! I am using a couple of Worksheet_Change functions in some worksheets, do those have an impact?

    Thank you! Please try to solve this issue because I did not find any solutions of it online!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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