selectionchange

What I am looking to do with this code is I want to look at cells B4:I38 and first see if they have been locked, if so than when a user selects a cell within that range the below message box (in the code) appears. But if the user selects a cell outside of that range than no message appears. So...

Hi, I have a worksheet that is not responding to worksheet events as I expect. Code is as follows... Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Count > 1 Then Exit Sub If Not Intersect(Target, Range("E4:P4")) Is Nothing Then MsgBox "New Cell Selected" End...

Instead of using radio buttons from the control toolbox, I have created a radio button type of group within 3 cells the code is as follows: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then [C1,E1].ClearContents If Target.Address = "$C$1" Then...

Hi, I need to resolve a pressing issue that I have at work. Here is my dilemma. Background Info: Currently, I have 15 users who submit data to me on Excel 2003 spreadsheets that I in turn manipulate to report elsewhere (to upper mgt, the government, etc…). In the short term, I need...

So what I want to do is enter yes or no into a cell and have YES answer run a macro and have NO answer run a macro. ... I am oh so close, the problem is that I can't get the code to run on the cell i enter yes or no into as once I hit enter the "ActiveCell" is now my new cell. What am i doing...