Tutorial na Macro na Excel 2003

Wannan koyaswar ta shafi yin amfani da mai rikodin macro don ƙirƙirar macro mai sauki a cikin Excel . Koyarwar ba ta rufe samarwa ko gyara wani macro ta yin amfani da editan VBA.

01 na 05

Fara Macro Recorder

Lura: Domin taimako akan waɗannan matakai, koma zuwa hoton da ke sama.

Hanyar mafi sauki don ƙirƙirar macro a Excel ita ce yin amfani da mai rikodin macro.

Don yin haka, danna Kayan aiki> Macros> Rubuta sabon Macro daga menus don kawo akwatin maganin Macro Record.

02 na 05

Zaɓuka na Macro Recorder

Lura: Domin taimako akan waɗannan matakai, koma zuwa hoton da ke sama.

Akwai zaɓuɓɓuka hudu don kammala a wannan akwatin zance:

1. Sunan - ba sunan macro naka.
2. Maɓallin gajeren hanya - (na zaɓi) ya cika wasika a wuri mai samuwa. Wannan zai ba ka damar tafiyar da macro ta hanyar riƙe da maballin CTRL kuma latsa harafin da aka zaɓa akan keyboard.
3. Ajiye Macro a -
   • Zabuka:
   • littafin aiki na yanzu
     • 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.
   • littafi na macro na sirri.
     • Wannan zaɓi yana ƙirƙirar fayil din - Personal.xls - wanda ke adana macros kuma ya sa su samuwa a gare ku a duk fayilolin Excel
4. Bayani - (na zaɓi) Shigar da bayanin Macro.

03 na 05

Macro Recorder Excel

Lura: Domin taimako akan waɗannan matakai, koma zuwa hoton da ke sama.

Lokacin da ka gama saitin zaɓuɓɓuka a cikin akwatin zance na Macro Recorder a matakin farko na wannan koyawa, danna maɓallin OK don fara mai rikodin macro.

Dole ne kayan aiki na Tsayawa Tsayawa ya kamata ya bayyana akan allon.

Mai rikodin macro ya rubuta dukkan keystrokes da kuma clicks na linzamin kwamfuta. Ƙirƙiri macro ta hanyar:

• da hannu tare da dukan matakan da ake bukata.
• A lokacin da aka gama, danna maɓallin dakatarwa (ƙananan blue square) akan tashar Tsayawa na Tsayawa Tsaya .
• Idan ba a samo kayan aiki na Tsayawa Tsaya ba, danna Kayan aiki> Macros> Tsaya rikodi daga menu don dakatar da rikodi.

04 na 05

Gudun Macro a Excel

Lura: Domin taimako akan waɗannan matakai, koma zuwa hoton da ke sama.

Don gudanar da macro da kuka rubuta:

• Idan ka zaɓi maɓallin gajeren hanya lokacin ƙirƙirar macro, riƙe ƙasa da maɓallin CTRL a kan maɓalli kuma latsa maɓallin gajeren hanya.

In ba haka ba,

1. Danna Kayan aiki> Macros> Macro daga menus don kawo akwatin kwance na Macro .
2. Zaɓi macro daga jerin wadanda akwai.
3. Danna maɓallin Run .

05 na 05

Ana gyara wani Macro

Lura: Domin taimako akan waɗannan matakai, koma zuwa hoton da ke sama.

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 zance na Macro ya fara da editan VBA (duba hoto a sama).

Kurakurori na Macro

Sai dai idan kun san VBA, sake yin rikodin macro wanda ba ya aiki daidai shi ne mafi kyawun zaɓi.