How do I correct this code: Private Sub WorksheetBeforeDoubleClick(ByVal Target As…
- User
How do I correct this code: Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Address = “D1” Then MsgBox ("AllBuildings PremMaint, School R&M Expenditure to include SCA, TSS710100 & vbNewLine & _ “GroundsMaint & TreeSurveys, Planned Grounds Maint, TSS760100” & vbNewLine & _ “CleaningContCosts, Cleaning Cont only, TSS730100” & vbNewLine & _ “CleaningMaterials, BlueRolls, ToiletRolls, CleanProducts, WasteBags, TSS730200” & vbNewLine & _ “WindowCleaning, TSS730300” & vbNewLine & _ “HygieneServicesCosts, ContHygServices, FHUunits etc, TSS760300” & vbNewLine & _ “WasteCollContract, ExtWasteCollection only, TSS760250” & vbNewLine & _ “WaterCastleWater Only, TSS760150” & vbNewLine & _ “GasCharges, Gas only, TSS720100” & vbNewLine & _ “ElectricityCharges, Electricity only, TSS720300” & vbNewLine & _ “AnnualRatesBill, TSS715100” & vbNewLine & _ “Health&Safety, FireAlarm, FirstAid supplies, PPE, WaterTesting, H&Scourses, PestCont, SecurityAlarm, Maint & CallOut, CCTV, TSS760350” & vbNewLine & _ “FurnitureLargeEquipment, Not Curriculum Exp, Chairs,Tables etc TSS810350”) Cancel = True End If
End Sub
- Assistant
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Address = "D1" Then MsgBox "AllBuildings PremMaint, School R&M Expenditure to include SCA, TSS710100" & vbNewLine & _ "GroundsMaint & TreeSurveys, Planned Grounds Maint, TSS760100" & vbNewLine & _ "CleaningContCosts, Cleaning Cont only, TSS730100" & vbNewLine & _ "CleaningMaterials, BlueRolls, ToiletRolls, CleanProducts, WasteBags, TSS730200" & vbNewLine & _ "WindowCleaning, TSS730300" & vbNewLine & _ "HygieneServicesCosts, ContHygServices, FHUunits etc, TSS760300" & vbNewLine & _ "WasteCollContract, ExtWasteCollection only, TSS760250" & vbNewLine & _ "WaterCastleWater Only, TSS760150" & vbNewLine & _ "GasCharges, Gas only, TSS720100" & vbNewLine & _ "ElectricityCharges, Electricity only, TSS720300" & vbNewLine & _ "AnnualRatesBill, TSS715100" & vbNewLine & _ "Health&Safety, FireAlarm, FirstAid supplies, PPE, WaterTesting, H&Scourses, PestCont, SecurityAlarm, Maint & CallOut, CCTV, TSS760350" & vbNewLine & _ "FurnitureLargeEquipment, Not Curriculum Exp, Chairs,Tables etc TSS810350"
Cancel = True End IfEnd Sub