Help understanding why this code wont work :(

L

Legacy 237453

Guest
Hi..

Can somebody please tell me why this code wont work.... I want it so that when i select cell J:7 the text in cells L:15 , L:17 & L:19 change

Code:
Private Sub worksheet_Selectionchange(ByVal Target As Range)
    Select Case Target.Address
    Case Is = "$J$7"
        Range("L15").Value = "No Callout nessasary"
        Range("L17").Value = "Multiple instructions please see values workbook"
        Range("L19").Value = "Processed data via SAP port"
    End Select
End Sub

Please can somebody explain what im doing wrong in a beginneer lol :)

Thanks as always!
Craig
 
L

Legacy 237453

Guest
Thanks for your reply... Can you explain the coulor change / bold part of the code to me please to help me understand rather than just asking on you guys all the time lol.
I cant see how the code knows that the word "not" is the word were working with? lol

Thanks Alot!
Craig
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Watch MrExcel Video

Forum statistics

Threads
1,128,107
Messages
5,628,729
Members
416,333
Latest member
Time2Learn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top