Results 1 to 18 of 18

Sheet Change Event Dubuggin: Restrict Cell Values toand Changing cells based on input

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-30-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    476

    Sheet Change Event Dubuggin: Restrict Cell Values toand Changing cells based on input

    Cannot debug worksheet change even below. If invalid entry entered change event is inoperable unless workbook closed and reopened. Goal is to
    1. Limit entries to VBA Array PTest (trying to avoid Data Validation, if possible?) 2. want to change column F to reflect date that corresponds to value inserted in PTest.

    Is this doable? I cannot even debugg to test, any suggestions?

        Build
        Application.EnableEvents = False
        
        If Target.Column = 3 And Target.Row = TestsTaken + 7 Then
            item = Cells(Target.Row, 3)
            If IsError(WorksheetFunction.Match(item, PTests, 0)) Then
                MsgBox "Please Insert Valid PTest"
                Cells(Target.Row, 3) = vbNullString
            Else: x = WorksheetFunction.Match(item, PTests, 0)
                
            Cells(Target.Row, 2) = Date + Time
            Cells(Target.Row, 1) = Target.Row - 6
            Cells(Target.Row, 3).Font.Color = 16711680
            Cells(Target.Row, 1).Resize(1, 2).HorizontalAlignment = xlCenter
            Cells(Target.Row, 6) = Application.Index(PTests, x, 0)
            End If
        End If
    
        TestsTaken = Sheet3.Cells(Distance, 1).End(xlDown)
        Build
        Application.EnableEvents = True
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Restrict Cells depending on input in another cell
    By Dave350z in forum Excel General
    Replies: 2
    Last Post: 01-28-2013, 11:38 AM
  2. Macro to replace cells value automatically based on another cell change event
    By phsilverhp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-09-2011, 04:36 AM
  3. Replies: 1
    Last Post: 05-05-2010, 04:18 AM
  4. Change Event based on two other cell values
    By carsto in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-10-2007, 05:15 PM
  5. New to excel, having trouble changing values based on an input cell
    By MyUserName in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-18-2006, 10:20 PM

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