MS Excel - B�i 8: Excel Macro ? tu dong hoa cac nhiem vu phuc tap

Macro l� m?t ch??ng tr�nh bao g?m c�c l?nh v� h�m ???c thi h�nh c�c thao t�c m?i khi b?n c?n. Macro c� th? t? ??ng th?c hi?n thao t�c v� l�m gi?m c�c b??c ?? ho�n th�nh nh?ng c�ng vi?c th??ng xuy�n.



C�ch ??n gi?n ?? t?o m?t Excel Macro l� c� b?n ghi c�c ho?t ??ng Excel v� l?u gi? n� nh? m?t macro. Macro c� th? ch?y l?i hay thay ??i b?t c? l�c n�o.



T?o macro



- T? menu Tools, ch?n Macro v� k�ch Record New Macro.



- H?p tho?i Record Macro hi?n th?, nh?p v�o t�n ? m?c Macro name

- Trong ph?n Description: m?c ??nh l� d?ng ?Macro recorded 8/26/2006 by SmartPoint? (t?c l� g?m c� ng�y th�ng v� t�n ng??i s? d?ng. N?u mu?n, b?n c� th? thay ??i)



- ?? b?t ??u ghi, k�ch OK



- Th?c hi?n c�c h�nh ??ng ?? macro ghi l?i, c�c h�nh ??ng n�y c� th? l� s? ph?i h?p nhi?u l?nh trong Excel.



- ?? d?ng ghi, t? menu Tools, ch?n Macro v� k�ch Stop Recording.



G�n m?t ph�m t?t cho macro



- T? menu Tools, ch?n Macro v� k�ch Macros.



- H?p tho?i Macros xu?t hi?n, ch?n t�n macro (n?u ?� l?u tr??c ?�) ?? g�n m?t ph�m t?t.

- K�ch n�t Options ?? hi?n th? h?p tho?i Macro Options



- T?i m?c Shortcut key, nh?p m?t k� t? v�o sau h?p Ctrl+ (v� d? Ctrl+ I). Ph�m t?t n�y s? ???c s? d?ng ?? g?i macro.



- K�ch OK ?? tr? v? h?p tho?i Macro



- K�ch n�t Cancel ?? b? qua h?p tho?i.



Ch?y macro s? d?ng c�ng c? l?nh



- T? menu Tools, ch?n Macro v� k�ch Macros.



- H?p tho?i Macro hi?n th?, trong m?c Macro name, ch?n t�n macro m� b?n mu?n ch?y



- K�ch n�t Run. Ch� �: N?u b?n mu?n thay ??i hay x�a macro, ch? c?n k�ch v�o n�t Edit hay Delete



Ch?y macro b?ng ph�m t?t



- ?n t? h?p ph�m Ctrl+? (v?i ? l� k� t? ?� g�n)



T?o m?t n�t l?nh v� g�n Excel macro



- N?u thanh c�ng c? Forms kh�ng hi?n th?, k�ch chu?t ph?i tr�n thanh c�ng c?, t? menu pop-up, ch?n Forms.



- ?? t?o m?t n�t l?nh, t? thanh c�ng c? Forms k�ch v�o bi?u t??ng Button

- Sau ?� d�ng chu?t k�o t?i v? tr� b?n mu?n, khi ?� xu�t hi?n d?u + v� b?n c� th? k�o t?i c? t�y �



- Khi nh? chu?t, h?p tho?i Assign Macro xu?t hi?n.

- K�ch n�t Record, h?p tho?i Record Macro xu?t hi?n



- T? m?c Macro name: nh?p t�n c?a macro c?n g?i



- K�ch n�t OK



- Khi ?�, macro ???c l?u l?i m?t c�ch th�ng th??ng, k�ch v�o n�t l?nh, ch?n Edit Text t? menu pop-up

- ?? ch?y macro, k�ch v�o n�t v?a t?o.



Thay ??i t�n button



- K�ch ?�p v�o button, khi ?� t�n button ???c ?�nh d?u



- G� v�o m?t t�n m?i v� k�ch v�o v�ng b?ng t�nh



X�a button



- K�ch v�o n�t v� ?n ph�m Delete

Submit Article :- Digg + Technorati + del.icio.us + Stumbleupon + Reddit + BlinkList + Furl + Yahoo+ Blogmarks + Ekstreme Socializer

|