Teremuyo "Chochitika cha Excel» amagwiritsidwa ntchito kusonyeza zochita zina zomwe munthu amagwiritsa ntchito mu Excel. Mwachitsanzo, pamene wogwiritsa ntchito asintha pepala la ntchito, ichi ndi chochitika. Kulowetsa deta mu selo kapena kusunga bukhu la ntchito kulinso zochitika za Excel.
Zochitika zitha kulumikizidwa ndi tsamba la Excel, ma chart, bukhu lantchito, kapena mwachindunji ku pulogalamu ya Excel yomwe. Okonza mapulogalamu amatha kupanga code ya VBA yomwe imangochitika zokha chochitika chikachitika.
Mwachitsanzo, kuti mukhale ndi macro kuthamanga nthawi iliyonse wogwiritsa ntchito akusintha tsamba lantchito mu Excel workbook, mutha kupanga code ya VBA yomwe imayendera nthawi iliyonse chochitikacho. SheetActivate buku la ntchito.
Ndipo ngati mukufuna kuti macro aziyenda nthawi iliyonse mukapita patsamba linalake (mwachitsanzo, Sheet1), ndiye VBA code iyenera kugwirizanitsidwa ndi chochitikacho yambitsa za pepala ili.
Khodi ya VBA yomwe ikufuna kuthana ndi zochitika za Excel iyenera kuyikidwa patsamba loyenera kapena buku lantchito pawindo la VBA mkonzi (mkonzi akhoza kutsegulidwa podina Alt + F11). Mwachitsanzo, kachidindo kamene kamayenera kuchitidwa nthawi iliyonse pamene chochitika china chikuchitika pa tsamba la ntchito chiyenera kuikidwa pawindo la code la tsambalo. Izi zikuwonetsedwa pachithunzichi:
Mu Visual Basic editor, mukhoza kuona mndandanda wa zochitika zonse za Excel zomwe zilipo pa bukhu la ntchito, tsamba la ntchito, kapena mulingo wa tchati. Tsegulani zenera la code la chinthu chomwe mwasankha ndikusankha mtundu wa chinthucho kuchokera kumanzere kumanzere pamwamba pa zenera. Menyu yotsikira kumanja pamwamba pa zenera iwonetsa zochitika zomwe zafotokozedwa pa chinthuchi. Chithunzi chomwe chili pansipa chikuwonetsa mndandanda wa zochitika zokhudzana ndi tsamba la Excel:
Dinani pa chochitika chomwe mukufuna pa menyu yotsikira kumanja, ndipo ndondomeko idzalowetsedwa pawindo la code ya chinthu ichi. Sub. pamutu wa ndondomekoyi Sub Excel imayika zokha mfundo zofunika (ngati zilipo). Zomwe zatsala ndikuwonjezera nambala ya VBA kuti muwone zomwe njirayo iyenera kuchita ikapezeka.
Mwachitsanzo
Muchitsanzo chotsatirachi, nthawi iliyonse cell ikasankhidwa B1 pa pepala la ntchito Sheet1 bokosi la mauthenga likuwonekera.
Kuti tichite izi, tifunika kugwiritsa ntchito tsamba lawebusayiti Selection_Change, zomwe zimachitika nthawi iliyonse kusankha kwa selo kapena ma cell angapo akusintha. Ntchito Selection_Change amalandira ngati mkangano chandamale chinthu -. Umu ndi momwe timadziwira kuti ndi maselo ati omwe adasankhidwa.
chochitika Selection_Change zimachitika ndi kusankha kwina kulikonse. Koma tifunika seti ya zochita kuti aphedwe kokha pamene selo yasankhidwa B1. Kuti tichite izi, tidzangoyang'anira zochitikazo pazokha zomwe zatchulidwa chandamale. Momwe imagwiritsidwira ntchito mu code code yomwe ili pansipa:
'Khodi yowonetsera bokosi la uthenga pamene selo B1 yasankhidwa' pa tsamba lamakono. Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'Chongani ngati selo B1 yasankhidwa Ngati Target.Count = 1 And Target.Row = 1 And Target.Column = 2 Ndiye 'Ngati selo B1 yasankhidwa, ndiye chitani zotsatirazi MsgBox "Muli ndi adasankha cell B1" End If End Sub