Wannan koyaswar ta shafi yin amfani da mai rikodin macro don ƙirƙirar macro mai sauki a cikin Excel . Mai rikodin macro yana aiki ta rikodin duk keystrokes da kuma danna daga linzamin kwamfuta. Macro da aka haɓaka a cikin wannan koyaswar zai shafi wasu zabin tsarawa zuwa maƙallin aikin aiki .
A cikin Excel 2007 da 2010, duk dokokin da aka shafi macro suna samuwa a kan shafin Developer na kintinkiri . Sau da yawa, wannan shafin yana buƙatar ƙarawa zuwa rubutun don samun dama ga umarnin macro. Batutuwa da wannan koyaswar take ciki sun hada da:
- Ƙara Tabbin Developer
- Fara fararen macro na Excel
- Zaɓuɓɓukan maɓallin rikodin Excel Excel
- Yi rikodin macro
- Gudun Macro
- Macro kurakurai / Ana gyara macro
01 na 06
Ƙara Tabbin Developer
- Danna kan fayil na rubutun don bude menu na fayil.
- Danna Zaɓuɓɓuka a cikin menu don buɗe akwatin maganganu na Excel Zabuka .
- Danna kan Zaɓuɓɓukan rubutun Ribbon a hannun hagu don duba samfuran da aka samo a cikin hannun dama na akwatin maganganu.
- A ƙarƙashin Shafuka na Maɓallai na zaɓuɓɓuka, window yana dubawa daga cikin zaɓi na Developer .
- Danna Ya yi.
- Dole ne a sami tabbacin shafin Developer a rubutun a Excel 2010.
Ƙara Tabbin Developer a Excel 2007
- A cikin Excel 2007, danna kan maɓallin Ofishin don buɗe menu da aka sauke.
- Danna maɓallin zaɓi na Excel wanda ke ƙasa a cikin menu domin buɗe akwatin maganganu na Excel Options .
- Danna kan zaɓi mai mahimmanci a saman hagu na hannun hagu na akwatin maganganun budewa.
- Danna kan Tabbacin Developer Tab din a cikin rubutun a hannun dama na taga na maganganun budewa.
- Danna Ya yi.
- Dole ne shafin Developer ya kasance a bayyane a cikin rubutun.
02 na 06
Ƙara wani Takarda Ayyukan Shafi / Aiki na Macro Recorder
Kafin mu fara rikodin macro, muna buƙatar ƙara da sunan aikin aiki wanda za mu tsara.
Tun da taken kowane nau'in takarda ya fi dacewa da wannan takardar aiki, ba mu so mu hada da take cikin macro. Saboda haka za mu kara da shi zuwa takardar aiki, kafin mu fara rikodin macro.
- Danna kan salula A1 a cikin takarda.
- Rubuta sunan: Kayan Kayan Kuki na Yuni 2008 .
- Latsa maɓallin shigarwa a kan keyboard.
Macro Recorder Excel
Hanyar mafi sauki don ƙirƙirar macro a Excel ita ce yin amfani da mai rikodin macro. Don yin haka:
- Danna kan shafin Masu Tsara .
- Danna Macro Record a cikin rubutun don bude akwatin maganin Macro Record .
03 na 06
Zaɓuka na Macro Recorder
Akwai 4 zaɓuɓɓuka don kammala a wannan akwatin zance:
- Sunan macro - ba sunan macro naka. Dole ne sunan ya fara da wasika da wurare ba a yarda. Sai kawai haruffa, lambobi da halin haɓakawa suna halatta.
- Maɓallin gajeren hanya - (na zaɓi) ya cika wasika, lambar, ko wasu haruffa a sararin samaniya. Wannan zai ba ka damar tafiyar da macro ta hanyar riƙe da maballin CTRL kuma latsa harafin da aka zaɓa akan keyboard.
- Ajiye Macro a
- Zabuka:
- Wannan littafi
- Macro yana samuwa ne kawai a cikin wannan fayil ɗin.
- Sabon littafi
- Wannan zaɓi yana buɗe sabon fayil ɗin Excel. Macro yana samuwa ne kawai a wannan sabon fayil.
- Littafin aikin macro na sirri.
- Wannan zaɓi yana ƙirƙirar Personal.xls mai ɓoye wanda ke adana Macros kuma ya sa su samuwa a gare ku a cikin dukkan fayilolin Excel.
- Bayani - (na zaɓi) shigar da bayanin Macro.
Don Wannan Koyarwar
- Saita zaɓuɓɓuka a akwatin maganin Macro na Record don daidaita waɗanda suke cikin hoton da ke sama.
- Kada ka danna OK - duk da haka - duba a kasa.
- Danna maɓallin OK a cikin akwatin Magana na Macro na Record yana fara rikodi macro da ka gano.
- Kamar yadda aka ambata a baya, mai rikodin macro yayi aiki ta rikodin duk keystrokes da kuma danna daga linzamin kwamfuta.
- Samar da matsakaitan macro ɗinku ya shafi danna kan wasu zaɓuɓɓukan tsari akan gidan shafin shafin rubutun tare da linzamin kwamfuta yayin da mai rikodin macro yana gudana.
- Je zuwa mataki na gaba kafin ka fara mai rikodin macro.
04 na 06
Yin rikodin Matakan Macro
- Danna maɓallin OK a cikin akwatin maganin Macro na Record don fara mai rikodin macro.
- Danna kan shafin shafin shafin rubutun.
- Sanya siffofin A1 zuwa F1 a cikin takardun aiki.
- Danna kan Haɗin da Cibiyar Cibiyar don sanya lakabi a tsakanin sel A1 da F1.
- Danna kan madogarar launi (kaman zane na iya) don buɗe jerin layi mai launi.
- Zaɓi Blue, Lissafi 1 daga jerin don kunna launi na baya daga cikin zaɓuɓɓukan da aka zaɓa zuwa blue.
- Danna kan gunkin Font Color (yana da babban harafi "A") don buɗe jerin layi na launi.
- Zaɓi Fira daga jerin don kunna rubutu a cikin zaɓaɓɓun sel zuwa farar fata.
- Danna kan gunkin Font Size (a sama da paintin zane) don bude jerin jerin sauƙi.
- Zaɓi 16 daga jerin don canza girman rubutun a cikin sassan da aka zaba zuwa maki 16.
- Danna kan shafin Developer na kintinkiri.
- Danna maɓallin rikodi na Tsayawa akan rubutun don dakatar da rikodi na macro.
- A wannan lokaci, maƙallin your aikin aiki ya zama kama da take a cikin hoto a sama.
05 na 06
Gudun Macro
Don gudanar da macro da kuka rubuta:
- Danna kan shafin Sheet2 a kasa daga cikin shafukan .
- Danna kan salula A1 a cikin takarda.
- Rubuta sunan: Kayan Kayan Kuki na Yuli 2008 .
- Latsa maɓallin shigarwa a kan keyboard.
- Danna kan shafin Developer na kintinkiri.
- Danna maballin Macros akan rubutun don kawo akwatin akwatin Macro na Macro .
- Danna kan macro format_titles a cikin sunan Macro sunan .
- Danna maɓallin Run .
- Matakan Macro ya kamata ya tafiyar da ta atomatik kuma yayi amfani da matakan tsara matakan da ake amfani da su a kan takardar 1.
- A wannan lokaci, take a kan aikin aiki 2 ya kamata kama da take a kan takarda aiki 1.
06 na 06
Kurakurori na Macro / Daidaita Macro
Kurakurori na Macro
Idan macro ɗinka bai yi kamar yadda aka sa ran ba, mafi sauki, kuma mafi kyawun zaɓi shine bi ka'idojin koyawa kuma sake rikodin macro.
Ana gyara / Mataki cikin Macro
An rubuta Macro Excel a cikin harshen Shirye-shiryen Kayayyakin Gida don Aikace-aikace (VBA).
Danna kan ko dai Maɓallin Shirya ko Mataki a cikin akwatin maganin Macro ya fara da editan VBA (duba hoto a sama).
Yin amfani da editan VBA da kuma rufe harsunan shirin VBA ya wuce iyakar wannan koyo.