Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0301· OpenAIAi2 WildChat-4.8M (AI2)

How do I correct this code: Private Sub WorksheetBeforeDoubleClick(ByVal Target As…

  1. 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

  2. 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 If
    

    End Sub