+ Reply to Thread
Results 1 to 5 of 5

Validation code

Hybrid View

  1. #1
    Valued Forum Contributor smuzoen's Avatar
    Join Date
    10-28-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2003/2007/2010
    Posts
    610

    Re: Validation code

    Could you post your code showing what you are doing
    when dealing with changes effected from within Range.Validation
    If you are using forms then the answer is no. From within a module it should. If you could post your code that triggers worksheet_change event and confirm that code is within a module and not a form
    Hope this helps.
    Anthony
    Pack my box with five dozen liquor jugs
    PS: Remember to mark your questions as Solved once you are satisfied. Please rate the answer(s) by selecting the Star in the lower left next to the Triangle. It is appreciated?

  2. #2
    Registered User
    Join Date
    01-24-2012
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2007/10
    Posts
    2

    Re: Validation code

    I appreciate the response. The answer is I am not using a form, only setting validation rules within several cells on a sheet, triggered by a change in upline cells. The result is like a bullet ricocheting around the worksheet, changing cell values based on newly updated validation rules (after I have set Application.EnableEvents=False.)

    Let me see if I can get some clean code in here... it is spread out amongst several Subs...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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