Ajalin "taron Excel»an yi amfani da shi don nuna wasu ayyuka da mai amfani ya yi a cikin Excel. Misali, lokacin da mai amfani ya canza takardar littafin aiki, wannan lamari ne. Shigar da bayanai a cikin tantanin halitta ko adana littafin aiki suma al'amuran Excel ne.
Ana iya haɗa abubuwan da suka faru zuwa takardar aikin Excel, zuwa sigogi, littafin aiki, ko kai tsaye zuwa aikace-aikacen Excel kanta. Masu shirye-shirye na iya ƙirƙirar lambar VBA da za a aiwatar ta atomatik lokacin da wani abu ya faru.
Misali, don samun macro gudu duk lokacin da mai amfani ya canza takardar aiki a cikin littafin aikin Excel, zaku ƙirƙiri lambar VBA wacce zata gudana duk lokacin da taron ya faru. Kunna Sheet littafin aiki.
Kuma idan kuna son macro ya gudana duk lokacin da kuka je takamaiman takaddun aiki (misali, Takardar1), to dole ne a haɗa lambar VBA tare da taron kunna ga wannan takardar.
Dole ne a sanya lambar VBA da aka yi niyya don gudanar da abubuwan da suka faru na Excel a cikin takaddun aiki da ya dace ko kayan aiki a cikin taga editan VBA (ana iya buɗe editan ta dannawa. Alt+F11). Misali, lambar da ya kamata a aiwatar da ita duk lokacin da wani abu ya faru a matakin takardar aiki ya kamata a sanya shi a cikin taga lambar don wannan takardar aikin. Ana nuna wannan a cikin adadi:
A cikin Editan Kayayyakin Kaya, zaku iya duba saitin duk abubuwan da suka faru na Excel da ake samu a littafin aiki, takardar aiki, ko matakin ginshiƙi. Bude taga lambar don abin da aka zaɓa kuma zaɓi nau'in abu daga menu mai saukarwa na hagu a saman taga. Menu mai saukewa na dama a saman taga zai nuna abubuwan da aka ayyana don wannan abu. Hoton da ke ƙasa yana nuna jerin abubuwan da suka faru da ke da alaƙa da takardar aikin Excel:
Danna kan abin da ake so a cikin menu mai saukewa na dama, kuma za a shigar da hanya ta atomatik a cikin taga lambar don wannan abu. sub. a shugaban hanya sub Excel ta atomatik yana shigar da hujjojin da ake buƙata (idan akwai). Abin da ya rage shi ne ƙara lambar VBA don ƙayyade ayyukan da ya kamata a yi lokacin da aka gano abin da ake so.
Example
A cikin misali mai zuwa, duk lokacin da aka zaɓi tantanin halitta B1 a kan takardar aiki Takardar1 akwatin saƙo ya bayyana.
Don aiwatar da wannan aikin, muna buƙatar amfani da taron takardar aikin Zabi_Chanji, wanda ke faruwa a duk lokacin da zaɓin tantanin halitta ko kewayon sel ya canza. Aiki Zabi_Chanji karba a matsayin hujja Target abu -. Wannan shine yadda muka san kewayon sel aka zaɓi.
Event Zabi_Chanji yana faruwa tare da kowane sabon zaɓi. Amma muna buƙatar saitin ayyuka da za a aiwatar kawai lokacin da aka zaɓi tantanin halitta B1. Don yin wannan, za mu biye da taron kawai a cikin kewayon da aka ƙayyade Target. Yadda ake aiwatar da shi a lambar shirin da aka nuna a ƙasa:
'Lambar don nuna akwatin saƙo lokacin da aka zaɓi cell B1' akan takardar aiki na yanzu. Mai zaman kansa Sub Worksheet_SelectionChange(ByVal Target As Range) 'Duba idan an zaɓi cell B1 If Target.Count = 1 And Target.Row = 1 And Target.Column = 2' Sannan 'Idan cell B1 aka zaɓi, to sai kuyi MsgBox mai zuwa "Kuna da an zaɓi cell B1" Ƙarshen Idan Ƙarshen Sub