Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jun 2002
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Run a macro when cell is entered (Excel 2000)

    Hi All ... I have a macro that will apply a list data validation to a given cell. The list is based on a named range. This named range varies based on the value of another cell. My question is this: How can I get this macro to run automatically when the cell is entered?

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Run a macro when cell is entered (Excel 2000)

    Cat,

    Don't delete your mail and repost it. I have just send you a reply that disappeared somewhere due to this. Anyhow, here is a possible solution to what you want, using the WorkSheet_Calculate event. This is because the worksheet_change event is not triggered when data validation is used for data entry. I use a dummy formula to trigger the 'calculate' event and some code in the Worksheet_calculate event to change the lists of products, depending on the vendor.
    Hope this helps.
    Attached Files Attached Files

  3. #3
    Lounger
    Join Date
    Jun 2002
    Posts
    44
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Run a macro when cell is entered (Excel 2000)

    Sorry, HP. I thought the original post was "too general" and that no one would help me then. I am now trying the WorkSheet_Calculate event. Thanks again.

Posting Permissions

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