Posts by mpparker

mpparker · May 24th 2018

Thanks again Carim, working now!

mpparker · May 23rd 2018

Thanks Carim, can you give me a quick example on how i would write this in a standard module.

Sorry I'm struggling with this one!

Regards
Martin

mpparker · May 23rd 2018

Hi All

I am using the following code inserted into a worksheet_change event with no problem... all working as expected, however, as I am wanting to move the code highlighted in red into a standard module as I will be checking hundreds of cells and the code required exceeds the permitted size allowed. My question is... how do I write the 'if not intersect......' code in a standard module, as i need to refer the code to a specific worksheet, lets say 'Sheet1'

Any help/pointers would be very much appreciated.

Code

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("d16")) Is Nothing Then
msgbox "Hello!"
End If
End Sub

Regards
Martin

Posts by mpparker

Using If Not Intersect(Target..... in Standard Code Module

Using If Not Intersect(Target..... in Standard Code Module

Using If Not Intersect(Target..... in Standard Code Module