User Profile

Collapse

Profile Sidebar

Collapse
RobinMurphy3804
RobinMurphy3804
Last Activity: Apr 1 '16, 04:06 PM
Joined: Mar 31 '16
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • RobinMurphy3804
    replied to Compile Error: Expected End Sub
    in Visual Basic
    Thank you so much for your help and advice! I have never worked with code before and am having to learn as I go.
    See more | Go to post

      Leave a comment:

    • RobinMurphy3804
      started a topic Compile Error: Expected End Sub
      in Visual Basic

      Compile Error: Expected End Sub

      I keep getting an error message for my code. I would greatly appreciate any help I can get. When someone Selects cell K74 and types in anything (usually "X"), I need a dialog box to pop up with a yes or no question. If yes, the X remains. If no, the macro will undo the X. Thank you so much for taking the time to help!

      Code:
      Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$K$74" Then
      ...
      See more | Go to post
      Last edited by Stewart Ross; Apr 1 '16, 12:44 PM. Reason: Added code tags for you
      No activity results to display
      Show More
      Working...