+ Reply to Thread
Results 1 to 4 of 4

Worksheet Change Event

  1. #1
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    Worksheet Change Event

    I want to run some code when a particular cell is changed. This is my code:
    Please Login or Register  to view this content.
    Is there a problem with this code as I can't input data into certain cells in the worksheet?
    Last edited by Aland2929; 05-05-2010 at 12:21 PM.

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: Worksheet Change Event

    I can't input data into certain cells in the worksheet
    Are you sure they're not locked?

    That code should not prevent entry in any cell.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Forum Contributor wamp's Avatar
    Join Date
    11-10-2008
    Location
    Norway
    MS-Off Ver
    97, 2000 & 2003 (diff. workstations)
    Posts
    184

    Re: Worksheet Change Event

    the worksheet-change event executes whenever anything is changed.
    if your particular cell is for example B3 then the correct code would be
    Please Login or Register  to view this content.
    however, as sweep said, your code shouldn't lock your sheet in any way.

  4. #4
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    Re: Worksheet Change Event

    Quote Originally Posted by wamp View Post
    the worksheet-change event executes whenever anything is changed.
    if your particular cell is for example B3 then the correct code would be
    Please Login or Register  to view this content.
    however, as sweep said, your code shouldn't lock your sheet in any way.
    Thank you for your response. The reason I can't enter input in certain columns is because I have created an EXTRACT range I am copying data to. The EXTRACT range is 5 columns and 6 rows and I was trying to enter data below this range?

+ 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