Consulting

Results 1 to 6 of 6

Thread: After exiting dropdown word doesn't go through "On-Exit" sub

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    May 2023
    Posts
    9
    Location

    After exiting dropdown word doesn't go through "On-Exit" sub

    I have a dropdown list that says Yes and No. Theres also a macro linked to it "On-Exit" which is :

    Sub Exit_DD_33()
    'ASZ 04/2023
    If ActiveDocument.FormFields("DD33").Result = "NON" Then Delete_Dropdown33
    End Sub
    
    Sub Delete_Dropdown33()
    'ASZ 04/2023
    ADMIN_unprotec
        ActiveDocument.Range(Start:=ActiveDocument.Bookmarks("StartDD33").Range.Start, End:=ActiveDocument.Bookmarks("EndDD33").Range.End).Select
        Selection.Delete
        ADMIN_protec
    End Sub

    For some reason it works for all the previous deletes but for this one it doesn't. Even tho it works when you go step by step. When just using tab after you chose No nothing happens.
    Last edited by Aussiebear; 05-03-2023 at 11:20 AM. Reason: Added code tags to supplied code

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •