Contents
Odhaahyada VBA ee Excel
Markaad ku qorayso koodka VBA ee Excel, qayb ka mid ah hawlwadeenada gudaha ku jira ayaa loo isticmaalaa tallaabo kasta. Hawlwadeenadani waxa ay u qaybsamaan xisaab, xadhig, isbarbardhig iyo hawlwadeeno macquul ah. Marka xigta, waxaan si faahfaahsan u eegi doonaa koox kasta oo ka mid ah hawl-wadeennada.
Hawl-wadeennada Xisaabta
Hawl-wadeennada xisaabta VBA-da ee ugu muhiimsan waxay ku taxan yihiin shaxda hoose.
Tiirka midig ee jaantusku wuxuu muujinayaa horumarka hawlwadeenka caadiga ah ee maqnaanshaha qawska. Markaad ku darto jaantusyada tibaaxaha, waxaad bedeli kartaa sida ay u kala horreeyaan bayaanada VBA-da loo fuliyo sidaad rabto.
Hawlwadeennada | Action | mudnaanta (1 - ugu sarreeya; 5 - ugu hooseeya) |
---|---|---|
^ | hawlwadeenka jibbaarada | 1 |
* | hawlwadeenka isku dhufashada | 2 |
/ | hawlwadeenka qaybta | 2 |
Qaybinta aan ka hadhin - waxay soo celisaa natiijada qaybinta laba lambar iyada oo aan wax ka dhiman. Tusaale ahaan, 74 soo celin doona natiijada 1 | 3 | |
Courage | Hawlwadeenka Modulo (haraadi) – waxa uu soo celiyaa inta hadhay ka dib marka uu qaybiyo laba lambar. Tusaale ahaan, 8 ka dhanka ah 3 soo celin doona natiijada 2. | 4 |
+ | Hawlwadeenka wax-ka-qabashada | 5 |
- | hawlwadeenka kala goynta | 5 |
Wadayaasha Xargaha
Hawlwadeenka xargaha aasaasiga ah ee Excel VBA waa hawlwadeenka isku xidhka & (isku dar):
Hawlwadeennada | Action |
---|---|
& | hawlwadeenka isku xidhka. Tusaale ahaan, odhaahda "A" & "B" soo celin doona natiijada AB. |
Wadayaasha Isbarbardhiga
Hawlwadeennada isbarbardhigga ayaa loo adeegsadaa in ay is barbar dhigaan laba tiro ama xargo oo ay ku soo celiyaan qiimaha boolean ee nooca ah Boolean (Run mise Been). Hawlwadeenada isbarbardhigga VBA-da ee ugu muhiimsan waxay ku taxan yihiin shaxdan:
Hawlwadeennada | Action |
---|---|
= | Si lamid ah |
<> | Uma sinna |
< | In ka yar |
> | Macluumaad intaas ka badan |
<= | In ka yar ama la siman |
>= | Ka weyn ama la siman |
Hawl wadeenada caqliga
Hawlwadeennada macquulka ah, sida kuwa isbarbardhigga ah, waxay soo celiyaan qiimaha boolean ee nooca ah Boolean (Run mise Been). Hawl-wadeennada macquulka ah ee Excel VBA waxay ku taxan yihiin shaxda hoose:
Hawlwadeennada | Action |
---|---|
Oo | hawlgalka isku xirka, hawlwadeen macquul ah И. Tusaale ahaan, odhaahda A iyo B soo laaban doona True, haddii A и B labaduba waa siman yihiin True, haddii kale soo noqo Beenta. |
Or | Hawlgalka kala qaybinta, hawlwadeen macquul ah OR. Tusaale ahaan, odhaahda A ama B soo laaban doona True, haddii A or B waa isku mid True, wuuna soo laaban doonaa Beenta, haddii A и B labaduba waa siman yihiin Beenta. |
Ma aha | Hawlgalka diidmada, hawlwadeen macquul ah MA. Tusaale ahaan, odhaahda Ma aha A soo laaban doona True, haddii A si siman Beenta, ama soo noqo Beenta, haddii A si siman True. |
Shaxda sare kuma taxna dhammaan hawl-wadeennada macquulka ah ee laga heli karo VBA. Liis dhamaystiran oo ah hawl wadeenada macquulka ah ayaa laga heli karaa Xarunta Horumarinta Visual Basic.
Hawlaha lagu dhex dhisay
Waxaa jira hawlo badan oo gudaha ku dhex jira oo laga heli karo VBA kuwaas oo la isticmaali karo marka kood la qorayo. Hoos waxaa ku qoran qaar ka mid ah kuwa ugu badan ee la isticmaalo:
function | Action | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
maanku | Soo celisa qiimaha saxda ah ee lambarka la bixiyay. Tusaale:
| ||||||||||||||||||||||
Taariikhda | Soo celisa jilaha ANSI ee u dhigma qiimaha nambarada cabbirka. Tusaale:
| ||||||||||||||||||||||
Taariikhda | Soo celisa taariikhda nidaamka hadda jira. | ||||||||||||||||||||||
TaariikhdaAdd | Wuxuu ku darayaa waqti go'an taariikhda la bixiyay. Shaqada syntax:
Aaway dooda bareeg ayaa go'aamisa nooca u dhexeeya wakhtiga lagu daray inta la bixiyay taariikhda qaddarka lagu sheegay doodda tirada. Argagax bareeg waxay qaadan kartaa mid ka mid ah qiyamka soo socda:
Tusaale:
| ||||||||||||||||||||||
DateDiff | Wuxuu xisaabiyaa tirada waqtiyada cayiman ee u dhexeeya labada taariikhood ee la bixiyay. Tusaale:
| ||||||||||||||||||||||
Maalinta | Soo celisaa tiro u dhiganta maalinta bisha ee taariikhda la cayimay. Tusaale: Maalinta («29/01/2015») soo celisa lambarka 29. | ||||||||||||||||||||||
saacad | Soo celisa tiro u dhiganta tirada saacadaha wakhtiga la siiyay. Tusaale: Saacad («22:45:00») soo celisa lambarka 22. | ||||||||||||||||||||||
Gudaha Str | Waxay qaadataa halbeeg iyo laba xadhig oo dood ahaan ah. Soo celiyaa booska uu ka dhacay xadhigga labaad gudaha kan hore, isagoo ka bilaabaya raadinta booska uu bixiyo tirooyin. Tusaale:
Fiiro gaar ah: Doodda tirada lama cayimi karo, taas oo ay xaaladdu tahay raadintu waxay ka bilaabataa xarafka ugu horreeya ee xadhigga lagu qeexay doodda labaad ee shaqada. | ||||||||||||||||||||||
Int | Waxay soo celisaa qaybta isugeynta lambarka la siiyay. Tusaale: Int (5.79) soo celinta natiijada 5. | ||||||||||||||||||||||
Isdate | dib Truehaddii qiimaha la siiyay ay tahay taariikh, ama Beenta - haddii aysan taariikhda ahayn. Tusaale:
| ||||||||||||||||||||||
Khalad | dib Truehaddii qiimaha la siiyay uu yahay qalad, ama Beenta - haddii aysan ahayn qalad. | ||||||||||||||||||||||
Maqan | Magaca dooda habraaca ikhtiyaarka ah waxa loo gudbiyaa dood ahaan shaqada. Maqan celinta Truehaddii aan wax qiimo ah loo gudbin dooda habraaca su'aasha. | ||||||||||||||||||||||
Is Number | dib Truehaddii qiimaha la siiyay loo dawayn karo sida lambar, haddii kale soo noqda Beenta. | ||||||||||||||||||||||
Left | Waxay soo celisaa tirada la cayimay ee xarfaha laga bilaabo bilowga xargaha la bixiyay. Shaqada syntax waa sidan:
halkaas oo line waa xariggii asalka ahaa, iyo dhererka waa tirada xarfaha soo laabanaya, laga bilaabo bilowga xargaha. Tusaale:
| ||||||||||||||||||||||
Len | Soo celisa tirada xarfaha xargaha. Tusaale: Len ("abcdej") soo celisa lambarka 7. | ||||||||||||||||||||||
Month | Soo celisaa tiro u dhiganta bisha taariikhda la bixiyay. Tusaale: Bisha(«29/01/2015») soo celisa qiimihii 1. | ||||||||||||||||||||||
Mid | Wuxuu ka soo celiyaa tirada la cayimay ee xarfaha bartamaha xargaha la siiyay. Shaqada syntax: Mid (line, bilow, dhererka) halkaas oo line waa xadhigii asalka ahaa bilow - booska bilowga xadhigga la soo saarayo, dhererka waa tirada xarfaha la soo saarayo. Tusaale:
| ||||||||||||||||||||||
daqiiqo | Soo celisa tiro u dhiganta tirada daqiiqadaha ee wakhtiga la siiyay. Tusaale: Daqiiqado («22:45:15») soo celisa qiimihii 45. | ||||||||||||||||||||||
Hadda | Soo celisa nidaamka hadda jira taariikhda iyo wakhtiga. | ||||||||||||||||||||||
Xuquuqda | Wuxuu soo celiyaa tirada la cayimay ee xarfaha laga soo bilaabo dhamaadka xargaha la siiyay. Shaqada syntax: Midigline, dhererka) Halkee line waa xariggii asalka ahaa, iyo dhererka waa tirada xarfaha la soo saarayo, laga soo bilaabo dhamaadka xargaha la siiyay. Tusaale:
| ||||||||||||||||||||||
labaad | Soo celisa tiro u dhiganta tirada ilbiriqsi ee wakhtiga la siiyay. Tusaale: Labaad («22:45:15») soo celisa qiimihii 15. | ||||||||||||||||||||||
Sqr | Waxay soo celisaa xidid laba jibaaran ee qiimaha tirada ee lagu gudbiyay dooda. Tusaale:
| ||||||||||||||||||||||
Time | Soo celisa wakhtiga nidaamka hadda jira. | ||||||||||||||||||||||
Ubound | Soo celiyaa qoraalka sare ee cabbirka habaynta la cayimay. Fiiro gaar ah: Arraysyada kala duwan, dood ikhtiyaari ah ayaa laga yaabaa inay noqoto tusaha cabbirka la soo celinayo. Haddii aan la cayimin, default waa 1. | ||||||||||||||||||||||
sanadkii | Soo celisaa tiro u dhiganta sanadka taariikhda la bixiyay. Tusaale: Sannad («29/01/2015») soo celisa qiimihii 2015. |
Liiskaan waxaa ku jira oo kaliya xulashada kuwa ugu badan ee lagu dhex dhisay Excel Visual Basic functional. Liis dhammaystiran oo ah hawlaha VBA ee diyaarka u ah in lagu isticmaalo macros Excel waxa laga heli karaa Xarunta Horumarinta Visual Basic.