Zamkatimu
Mawu a Excel VBA
Polemba khodi ya VBA ku Excel, ma opareshoni omwe adamangidwa amagwiritsidwa ntchito pagawo lililonse. Ogwira ntchitowa amagawidwa m'masamu, zingwe, zofananitsa ndi zomveka. Kenaka, tiwona gulu lirilonse la ogwira ntchito mwatsatanetsatane.
Othandizira Masamu
Ogwiritsa ntchito masamu a VBA akulu adalembedwa patebulo pansipa.
Mzere wakumanja wa tebulo ukuwonetsa wotsogolera wokhazikika ngati palibe mabatani. Powonjezera mabatani ku mawu, mutha kusintha momwe mawu a VBA amachitira momwe mukufunira.
Woyendetsa | Action | chofunika kwambiri (1 - apamwamba; 5 - otsika) |
---|---|---|
^ | wotsogolera exponentiation | 1 |
* | wochulukitsa | 2 |
/ | woyendetsa magawo | 2 |
Kugawa popanda chotsalira - kumabweretsa zotsatira za kugawa manambala awiri popanda chotsalira. Mwachitsanzo, 74 adzabwezera zotsatira 1 | 3 | |
mtima | Wogwiritsa ntchito Modulo (otsalira) - amabwezera chotsalira pambuyo pogawa manambala awiri. Mwachitsanzo, 8 pa 3 adzabwezera zotsatira 2. | 4 |
+ | Wothandizira wowonjezera | 5 |
- | wothandizira kuchotsa | 5 |
Ogwiritsa Ntchito zingwe
Woyambira zingwe mu Excel VBA ndiye wogwiritsa ntchito concatenation & (kuphatikiza):
Woyendetsa | Action |
---|---|
& | wogwiritsa ntchito concatenation. Mwachitsanzo, mawu "A" & "B" adzabwezera zotsatira AB. |
Ofanizira Oyerekeza
Ofananitsa amagwiritsidwa ntchito kuyerekeza manambala awiri kapena zingwe ndikubweza mtengo wa boolean wa mtundu Boolean (Zoona kapena Zonama). Ogwiritsa ntchito kwambiri a Excel VBA alembedwa patebulo ili:
Woyendetsa | Action |
---|---|
= | Mofanana |
<> | Osafanana |
< | Zochepa |
> | Zambiri |
<= | Zocheperapo kapena zofanana |
>= | Chachikulu kuposa kapena chofanana |
Ogwira ntchito zomveka
Ogwiritsa ntchito mwanzeru, monga ofananitsa, amabwezera mtundu wa boolean mtengo Boolean (Zoona kapena Zonama). Ogwiritsa ntchito mwanzeru a Excel VBA adalembedwa patebulo ili pansipa:
Woyendetsa | Action |
---|---|
ndipo | ntchito yolumikizana, wogwiritsa ntchito zomveka И. Mwachitsanzo, mawu A ndi B adzabwerera N'zoona, ngati A и B onse ndi ofanana N'zoona, apo ayi bwererani chonyenga. |
Or | Ntchito yosokoneza, wogwiritsa ntchito zomveka OR. Mwachitsanzo, mawu A kapena B adzabwerera N'zoona, ngati A or B ndi ofanana N'zoona, ndipo adzabweranso chonyenga, ngati A и B onse ndi ofanana chonyenga. |
osati | Opaleshoni yotsutsa, wogwiritsa ntchito zomveka OSATI. Mwachitsanzo, mawu Ayi A adzabwerera N'zoona, ngati A mofanana chonyenga, kapena kubwerera chonyenga, ngati A mofanana N'zoona. |
Gome ili pamwambapa silinatchule onse ogwira ntchito zomveka omwe alipo mu VBA. Mndandanda wathunthu wa ogwiritsa ntchito mwanzeru ungapezeke pa Visual Basic Developer Center.
Ntchito Zomangidwa
Pali ntchito zambiri zomangidwa zomwe zikupezeka mu VBA zomwe zingagwiritsidwe ntchito polemba ma code. Pansipa pali ena mwa omwe amagwiritsidwa ntchito kwambiri:
ntchito | Action | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Mph | Imabweza mtengo wokwanira wa nambala yomwe wapatsidwa. Chitsanzo:
| ||||||||||||||||||||||
BC | Imabweza chilembo cha ANSI chogwirizana ndi mtengo wa nambala ya chizindikirocho. Chitsanzo:
| ||||||||||||||||||||||
Date | Ikubweza tsiku ladongosolo lapano. | ||||||||||||||||||||||
DateAdd | Imawonjezera nthawi yodziwika ku tsiku lomwe laperekedwa. Kalembedwe ka ntchito:
Mkangano uli kuti mpata imatsimikizira mtundu wa nthawi yowonjezeredwa ku zomwe zaperekedwa tsiku mu ndalama zomwe zafotokozedwa mumtsutso nambala. Kutsutsana mpata ikhoza kutenga chimodzi mwazinthu zotsatirazi:
Chitsanzo:
| ||||||||||||||||||||||
DateDiff | Imawerengetsera kuchuluka kwa nthawi yodziwika pakati pa masiku awiri operekedwa. Chitsanzo:
| ||||||||||||||||||||||
tsiku | Imabweza nambala yonse yolingana ndi tsiku la mwezi womwe waperekedwa. Chitsanzo: Tsiku («29/01/2015») akubweza nambala 29. | ||||||||||||||||||||||
Ora | Imabwezera nambala yolingana ndi kuchuluka kwa maola pa nthawi yomwe yaperekedwa. Chitsanzo: Ola («22:45:00») akubweza nambala 22. | ||||||||||||||||||||||
InStr | Zimatengera chiwerengero chokwanira ndi zingwe ziwiri monga zotsutsana. Imabwezeranso pomwe chingwe chachiwiri chikachitika pakati pa koyamba, kuyambira kusaka pamalo operekedwa ndi nambala yonse. Chitsanzo:
Zindikirani: Kutsutsana kwa nambala sikungatchulidwe, pomwe kusaka kumayambira pamtundu woyamba wa chingwe chomwe chafotokozedwa mumtsutso wachiwiri wa ntchitoyi. | ||||||||||||||||||||||
Int | Imabweza gawo lalikulu la nambala yoperekedwa. Chitsanzo: Int (5.79) zotsatira 5. | ||||||||||||||||||||||
Isdate | Kubwerera N'zoonangati mtengo womwe wapatsidwa ndi tsiku, kapena chonyenga - ngati tsikulo siliri. Chitsanzo:
| ||||||||||||||||||||||
IsError | Kubwerera N'zoonangati mtengo womwe wapatsidwa ndi cholakwika, kapena chonyenga - ngati sikulakwa. | ||||||||||||||||||||||
Palibe | Dzina la mkangano wosankha umaperekedwa ngati mtsutso ku ntchitoyo. Palibe akadzabweranso N'zoonangati palibe phindu lomwe linaperekedwa pa ndondomeko yomwe ikufunsidwa. | ||||||||||||||||||||||
NdiNumeric | Kubwerera N'zoonangati mtengo womwe wapatsidwa ukhoza kuwonedwa ngati nambala, apo ayi kubwereranso chonyenga. | ||||||||||||||||||||||
kumanzere | Imabweza chiwerengero cha zilembo zomwe zatchulidwa kuyambira pachiyambi cha chingwe chomwe chaperekedwa. Syntax ya ntchito ili motere:
kumene mzere ndi chingwe choyambirira, ndi Kutalika ndi chiwerengero cha zilembo zobwerera, kuwerengera kuyambira pachiyambi cha chingwe. Chitsanzo:
| ||||||||||||||||||||||
Len | Kubweza chiwerengero cha zilembo mu chingwe. Chitsanzo: Len ("abcdej") akubweza nambala 7. | ||||||||||||||||||||||
mwezi | Imabweza nambala yonse yolingana ndi mwezi wa tsiku lomwe laperekedwa. Chitsanzo: Mwezi («29/01/2015») amabwezera mtengo 1. | ||||||||||||||||||||||
Miyezi | Imabweza chiwerengero cha zilembo zomwe zatchulidwa pakati pa zingwe zomwe zaperekedwa. Kalembedwe ka ntchito: Pakati (mzere, chiyambi, Kutalika) kumene mzere ndiye chingwe choyambirira chiyambi - malo a chiyambi cha chingwe chomwe chiyenera kuchotsedwa, Kutalika ndi chiwerengero cha zilembo zomwe ziyenera kuchotsedwa. Chitsanzo:
| ||||||||||||||||||||||
Minute | Imabwezera nambala yolingana ndi nambala ya mphindi mu nthawi yoperekedwa. Chitsanzo: Mphindi («22:45:15») amabwezera mtengo 45. | ||||||||||||||||||||||
Tsopano | Ikubweza deti ndi nthawi yadongosolo. | ||||||||||||||||||||||
Chabwino | Imabweza chiwerengero cha zilembo zomwe zatchulidwa kumapeto kwa chingwe chomwe chaperekedwa. Kalembedwe ka ntchito: Kumanja (mzere, Kutalika) Kodi mzere ndi chingwe choyambirira, ndi Kutalika ndi chiwerengero cha zilembo zochotsedwa, kuwerengera kuchokera kumapeto kwa chingwe choperekedwa. Chitsanzo:
| ||||||||||||||||||||||
Chachiwiri | Imabweza chiwerengero chofanana ndi chiwerengero cha masekondi mu nthawi yoperekedwa. Chitsanzo: Chachiwiri («22:45:15») amabwezera mtengo 15. | ||||||||||||||||||||||
Sqr | Imabweza sikweya mizu ya nambala yomwe yadutsa mumtsutso. Chitsanzo:
| ||||||||||||||||||||||
Time | Imabwezeranso nthawi yadongosolo. | ||||||||||||||||||||||
Ubound | Imabwezeranso mawu apamwamba amtundu womwe wasankhidwa. Zindikirani: Pamagulu ambiri, mkangano wosankha ukhoza kukhala mlozera woti mubwererenso. Ngati sichinatchulidwe, chokhazikika ndi 1. | ||||||||||||||||||||||
chaka | Imabweza chiwerengero chofanana ndi chaka cha deti loperekedwa. Chitsanzo: Chaka («29/01/2015») amabwezera mtengo 2015. |
Mndandandawu umaphatikizapo kusankha kwa ntchito zomwe zimagwiritsidwa ntchito kwambiri mu Excel Visual Basic. Mndandanda wokwanira wa ntchito za VBA zomwe zingagwiritsidwe ntchito mu Excel macros zitha kupezeka pa Visual Basic Developer Center.