Mukati
Excel VBA zvinyorwa
Paunenge uchinyora VBA kodhi muExcel, seti yeakavakirwa-mukati maopareta anoshandiswa pamatanho ese. Aya maopareta akakamurwa kuita masvomhu, tambo, kuenzanisa uye zvine musoro. Zvadaro, tichatarisa boka rega rega revashandi zvakadzama.
Mathematics Operators
Iwo makuru eVBA math operators akanyorwa patafura pazasi.
Koramu yekurudyi yetafura inoratidza iyo default opareta kutangira mukushaikwa kwevabereki. Nekuwedzera maparentheses kune chirevo, unogona kushandura kurongeka uko zvirevo zveVBA zvinoitwa sezvaunoda.
Operator | Action | chikosheshwa (1 - yepamusorosoro; 5 - yakaderera) |
---|---|---|
^ | exponentiation operator | 1 |
* | kuwanza mushandisi | 2 |
/ | division operator | 2 |
Kupatsanura pasina kusara - inodzosera mhedzisiro yekukamura nhamba mbiri pasina chasara. Semuyenzaniso, 74 ichadzorera mhedzisiro 1 | 3 | |
chivindi | Modulo (yasara) opareta - inodzosa zvakasara mushure mekupatsanura nhamba mbiri. Semuyenzaniso, 8 Kupesana ne3 ichadzorera mhedzisiro 2. | 4 |
+ | Kuwedzera opareta | 5 |
- | kubvisa mushandisi | 5 |
Vashandi veTambo
Iyo yakakosha tambo opareta muExcel VBA ndiye concatenation opareta & (batanidza):
Operator | Action |
---|---|
& | concatenation operator. Somuenzaniso, chirevo "A" uye "B" ichadzorera mhedzisiro AB. |
Kufananidza Vashandisi
Vashandisi vekuenzanisa vanoshandiswa kuenzanisa nhamba mbiri kana tambo uye kudzorera kukosha kweboolean yemhando boolean (Chokwadi kana Nhema). Iwo makuru eExcel VBA ekuenzanisa anoshanda akanyorwa mune iyi tafura:
Operator | Action |
---|---|
= | Zvakaenzana |
<> | Kwete kuenzana |
< | Kuderera |
> | Mamwe mashoko |
<= | Zvishoma pane kana kuenzana |
>= | Mukuru pane kana kuenzana |
Vashandisi vane musoro
Vanoshandisa zvine musoro, sevashandisi vekuenzanisa, vanodzosa kukosha kweboolean yemhando boolean (Chokwadi kana Nhema). Iwo makuru ane musoro anoshanda eExcel VBA akanyorwa patafura pazasi:
Operator | Action |
---|---|
uye | mubatanidzwa kushanda, zvine musoro mushandisi И. Somuenzaniso, chirevo A uye B vachadzoka chokwadi, kana A и B zvose zvakaenzana chokwadi, zvikasadaro dzokai venhema. |
Or | Disjunction operation, logic operator OR. Somuenzaniso, chirevo A kana B vachadzoka chokwadi, kana A or B vakaenzana chokwadi, uye ndichadzoka venhema, kana A и B zvose zvakaenzana venhema. |
kwete | Negation operation, logic operator NOT. Somuenzaniso, chirevo Kwete A vachadzoka chokwadi, kana A zvakaenzana venhema, kana kudzoka venhema, kana A zvakaenzana chokwadi. |
Tafura iri pamusoro hainyore vese vane musoro vanoshanda muVBA. Rondedzero yakazara yevashandisi vane musoro inogona kuwanikwa paVisual Basic Developer Center.
Yakavakwa-mukati Mabasa
Kune akawanda akavakirwa-mukati mabasa anowanikwa muVBA anogona kushandiswa pakunyora kodhi. Zvinyorwa pasi apa ndezvimwe zvezvinonyanya kushandiswa:
basa | Action | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
abs | Inodzosa kukosha kweiyo nhamba yakapihwa. muenzaniso:
| ||||||||||||||||||||||
Chr | Inodzosa mavara eANSI anoenderana nenhamba kukosha kweparameter. muenzaniso:
| ||||||||||||||||||||||
zuva | Inodzosa zuva rehurongwa hwazvino. | ||||||||||||||||||||||
DateAdd | Inowedzera nguva yakatarwa kune zuva rakapihwa. Sintax yebasa:
Nharo iripi chinguva inotara mhando yenguva yenguva yakawedzerwa kune yakapihwa zuva mumari yakataurwa munharo nhamba. Argument chinguva inogona kutora chimwe chezvinotevera zvakakosha:
muenzaniso:
| ||||||||||||||||||||||
DateDiff | Inoverengera nhamba yenguva yakatarwa pakati pemazuva maviri akapihwa. muenzaniso:
| ||||||||||||||||||||||
zuva | Inodzosa nhamba inoenderana nezuva remwedzi muzuva rakapihwa. muenzaniso: Zuva(«29/01/2015») inodzosera nhamba 29. | ||||||||||||||||||||||
awa | Inodzosa nhamba inoenderana nenhamba yemaawa panguva yakapihwa. muenzaniso: Awa(«22:45:00») inodzosera nhamba 22. | ||||||||||||||||||||||
InStr | Zvinotora nhamba netambo mbiri senharo. Inodzosa nzvimbo yekuitika kwetambo yechipiri mukati mekutanga, kutanga kutsvaga panzvimbo yakapihwa nenhamba. muenzaniso:
Cherechedza: Nharo yenhamba haigone kutaurwa, apa kutsvaga kunotanga kubva pamavara ekutanga etambo inotsanangurwa munharo yechipiri yebasa. | ||||||||||||||||||||||
Int | Inodzosa chikamu chizere chenhamba yakapihwa. muenzaniso: Int(5.79) inodzosera mhinduro 5. | ||||||||||||||||||||||
Isdate | Returns chokwadikana kukosha kwakapihwa iri zuva, kana venhema - kana zuva risiri. muenzaniso:
| ||||||||||||||||||||||
IsError | Returns chokwadikana kukosha kwakapihwa kuri kukanganisa, kana venhema - kana isiri kukanganisa. | ||||||||||||||||||||||
IsMissing | Zita resarudzo yemaitiro nharo rinopfuudzwa senharo kubasa. IsMissing inodzoka chokwadikana pasina kukosha kwakapfuudzwa kune iyo nzira gakava iri mubvunzo. | ||||||||||||||||||||||
IsNumeric | Returns chokwadikana kukosha kwakapihwa kunogona kubatwa senhamba, zvikasadaro inodzoka venhema. | ||||||||||||||||||||||
Ruboshwe | Inodzosa nhamba yakatarwa yemavara kubva panotangira tambo yakapihwa. Basa re syntax rakaita seizvi:
apo mutsetse ndiyo tambo yepakutanga, uye Kureba inhamba yemavara ekudzoka, kuverenga kubva panotangira tambo. muenzaniso:
| ||||||||||||||||||||||
Len | Inodzosa nhamba yemavara mutambo. muenzaniso: Len ("abcdej") inodzosera nhamba 7. | ||||||||||||||||||||||
Mwedzi | Inodzosa nhamba inoenderana nemwedzi wezuva rakapihwa. muenzaniso: Mwedzi(«29/01/2015») inodzorera kukosha kwe1. | ||||||||||||||||||||||
Mid | Inodzosa nhamba yakatarwa yemavara kubva pakati petambo yakapihwa. Sintax yebasa: Pakati (mutsetse, kutanga, Kureba) apo mutsetse ndiyo tambo yepakutanga kutanga - nzvimbo yepakutanga kwetambo inofanira kubudiswa, Kureba inhamba yemavara achatorwa. muenzaniso:
| ||||||||||||||||||||||
Mineti | Inodzosa nhamba inoenderana nenhamba yemaminetsi panguva yakapihwa. Muenzaniso: Miniti(«22:45:15») inodzorera kukosha kwe45. | ||||||||||||||||||||||
ikozvino | Inodzosa yazvino system date uye nguva. | ||||||||||||||||||||||
Rudyi | Inodzosa nhamba yakatarwa yemavara kubva kumagumo etambo yakapihwa. Sintax yebasa: Rudyi(mutsetse, Kureba) apo mutsetse ndiyo tambo yepakutanga, uye Kureba inhamba yemavara ekutora, kuverenga kubva kumagumo etambo yakapihwa. muenzaniso:
| ||||||||||||||||||||||
Chepiri | Inodzosa nhamba inoenderana nenhamba yemasekonzi panguva yakapihwa. muenzaniso: Chechipiri(«22:45:15») inodzorera kukosha kwe15. | ||||||||||||||||||||||
Sqr | Inodzosa sikweya midzi yenhamba yeukoshi hwapfuura munharo. muenzaniso:
| ||||||||||||||||||||||
nguva | Inodzosa ikozvino system nguva. | ||||||||||||||||||||||
Ubound | Inodzosa zvinyorwa zvepamusoro zvearongedzero yakataurwa. Cherechedza: Kumadimensional arrays, nharo yesarudzo inogona kunge iri indekisi yekuti ndeupi udzoke. Kana zvisina kutaurwa, iyo default ndeye 1. | ||||||||||||||||||||||
gore | Inodzosa nhamba inoenderana negore rezuva rakapihwa. Muenzaniso: Gore(«29/01/2015») inodzorera kukosha kwe2015. |
Iyi rondedzero inosanganisira chete sarudzo yeanonyanya kushandiswa akavakirwa-muExcel Visual Basic mabasa. Rondedzero yakazara yeVBA mabasa anowanikwa kuti ashandiswe muExcel macros anogona kuwanikwa paVisual Basic Developer Center.