{"id":5630,"date":"2024-12-16T16:48:13","date_gmt":"2024-12-16T16:48:13","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/thiet-lap-lenh-in-tu-dong-trong-excel-voi-vba\/"},"modified":"2024-12-16T16:48:13","modified_gmt":"2024-12-16T16:48:13","slug":"thiet-lap-lenh-in-tu-dong-trong-excel-voi-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/thiet-lap-lenh-in-tu-dong-trong-excel-voi-vba\/","title":{"rendered":"Thi\u1ebft l\u1eadp l\u1ec7nh in t\u1ef1 \u0111\u1ed9ng trong Excel v\u1edbi VBA"},"content":{"rendered":"
\n

Trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n (ho\u1eb7c c\u00f4ng vi\u1ec7c t\u01b0\u01a1ng t\u1ef1) c\u1ea7n in\u00a0\u1ea5n ch\u1ee9ng t\u1eeb, s\u1ed5 s\u00e1ch nhi\u1ec1u. Vi\u1ec7c thi\u1ebft l\u1eadp trang in m\u1ed9t c\u00e1ch t\u1ef1\u00a0\u0111\u1ed9ng l\u00e0\u00a0\u0111i\u1ec1u h\u1ebft s\u1ee9c c\u1ea7n thi\u1ebft cho ch\u00fang ta, gi\u00fap ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c. B\u1ea1n ngh\u0129 sao khi c\u00f3 th\u1ec3 d\u00f9ng 1 n\u00fat l\u1ec7nh\u00a0\u0111\u1ec3\u00a0\u0111\u01b0a b\u1ea3ng d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p v\u1ec1 chu\u1ea9n\u00a0\u0111\u1ecbnh d\u1ea1ng in nh\u01b0 mong mu\u1ed1n? Ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u b\u00e0i h\u1ecdc n\u00e0y nh\u00e9.<\/p>\n

V\u00ed d\u1ee5:<\/strong><\/p>\n

Cho m\u1eabu s\u1ed5 Nh\u1eadt k\u00fd chung c\u00f3 t\u1edbi 1000 d\u00f2ng, trong\u00a0\u0111\u00f3 c\u00f3 m\u1ed9t s\u1ed1 d\u00f2ng nh\u1ea5t\u00a0\u0111\u1ecbnh c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n

<\/p>\n

M\u1ee5c ti\u00eau<\/strong>: T\u1ea1o n\u00fat l\u1ec7nh in, khi b\u1ea5m v\u00e0o n\u00fat l\u1ec7nh\u00a0\u0111\u00f3 th\u00ec s\u1ed5 NKC s\u1ebd\u00a0\u0111\u01b0a v\u1ec1 chu\u1ea9n\u00a0\u0111\u1ecbnh d\u1ea1ng cu\u1ed1i c\u00f9ng c\u1ea7n in.<\/p>\n

H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u00e0m:<\/strong><\/p>\n

B\u01b0\u1edbc 1: Thi\u1ebft l\u1eadp v\u00f9ng in<\/strong><\/p>\n

Trong tab\u00a0 Page Layout, b\u1ea5m v\u00e0o v\u1ecb tr\u00ed sau\u00a0\u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 Page Setup:<\/p>\n

\n
\n

D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n


\n
\n<\/a>\n<\/div>\n<\/div>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

<\/p>\n

Trong c\u1eeda s\u1ed5 Page Setup, ch\u00fang ta thi\u1ebft l\u1eadp v\u00f9ng in (Print\u00a0Area) v\u00e0 D\u00f2ng l\u1eb7p l\u1ea1i trong m\u1ed7i trang (d\u00f2ng ti\u00eau\u00a0\u0111\u1ec1 c\u1ee7a b\u1ea3ng = Rows to repeat at top, d\u00f2ng 5\u00a0\u0111\u1ebfn d\u00f2ng 7)<\/p>\n

<\/p>\n

Vi\u1ec7c thi\u1ebft l\u1eadp v\u00f9ng in s\u1ebd gi\u00fap cho ch\u00fang ta c\u00f3 th\u1ec3\u00a0\u0111\u1eb7t v\u00f9ng in\u00a0\u1edf b\u1ea5t k\u1ef3 v\u1ecb tr\u00ed n\u00e0o trong Sheet m\u00e0 v\u1eabn c\u00f3 th\u1ec3 khi\u00a0\u0111\u01b0a l\u00ean d\u1ea1ng in s\u1ebd ch\u1ec9 in c\u00e1c n\u1ed9i dung\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn, tr\u00e1nh in ph\u1ea3i nh\u1eefng n\u1ed9i dung th\u1eeba kh\u00f4ng mong mu\u1ed1n.<\/p>\n

\n

\u0110\u0103ng k\u00ed ngay:\u00a0l\u1edbp h\u1ecdc VBA \u1edf H\u00e0 N\u1ed9i<\/a><\/p>\n<\/blockquote>\n

B\u01b0\u1edbc 2: T\u1ea1o c\u1ed9t ph\u1ee5 gi\u00fap l\u1ecdc b\u1ecf nh\u1eefng d\u00f2ng th\u1eeba trong s\u1ed5 NKC<\/strong><\/p>\n

V\u00ec vi\u1ec7c l\u1eadp s\u1eb5n 1000 d\u00f2ng \u0111\u1ec3 gi\u00fap ch\u00fang ta c\u00f3 th\u1ec3 nh\u1eadp b\u1ed5 sung d\u1eef li\u1ec7u t\u00f9y \u00fd v\u00e0o s\u1ed5, tuy nhi\u00ean vi\u1ec7c n\u00e0y t\u1ea1o ra\u00a0c\u00e1c d\u00f2ng tr\u1ed1ng ch\u01b0a d\u00f9ng\u00a0\u0111\u1ebfn => Kh\u00f4ng s\u1eed d\u1ee5ng khi in s\u1ed5 => C\u1ea7n ph\u1ea3i l\u1ecdc\u00a0\u0111\u1ec3\u00a0\u1ea9n\u00a0\u0111i tr\u01b0\u1edbc khi in<\/p>\n

Logic l\u1ecdc nh\u01b0 sau: N\u1ebfu d\u00f2ng trong s\u1ed5 NKC c\u00f3 d\u1eef li\u1ec7u th\u00ec l\u1ea5y gi\u00e1 tr\u1ecb (v\u00ed d\u1ee5 l\u00e0 gi\u00e1 tr\u1ecb x), n\u1ebfu kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u th\u00ec s\u1ebd ra k\u1ebft qu\u1ea3 r\u1ed7ng<\/p>\n

B8=IF(C8=\u201d\u201d,\u201d\u201d,\u201dx\u201d)<\/p>\n

Ch\u00fang ta filldown c\u00f4ng th\u1ee9c t\u1eeb\u00a0\u00f4 B8 xu\u1ed1ng c\u00e1c d\u00f2ng ti\u1ebfp theo\u00a0\u0111\u1ebfn h\u1ebft c\u00e1c d\u00f2ng trong s\u1ed5<\/p>\n

C\u00f2n c\u00e1c d\u00f2ng\u00a0\u1edf cu\u1ed1i s\u1ed5 (T\u1ed5ng c\u1ed9ng, ng\u00e0y th\u00e1ng, ng\u01b0\u1eddi k\u00fd\u2026) s\u1ebd lu\u00f4n lu\u00f4n c\u00f3 tr\u00ean s\u1ed5, do\u00a0\u0111\u00f3 ch\u00fang ta c\u00f3 th\u1ec3\u00a0\u0111\u1eb7t s\u1eb5n gi\u00e1 tr\u1ecb x v\u00e0o t\u1ea5t c\u1ea3 nh\u1eefng d\u00f2ng\u00a0\u0111\u00f3<\/p>\n

<\/p>\n

V\u00f9ng k\u1ebb vi\u1ec1n m\u00e0u\u00a0\u0111\u1ecf: L\u00e0 v\u00f9ng ch\u1ee9a c\u00f4ng th\u1ee9c l\u1ecdc ph\u00e1t sinh<\/p>\n

V\u00f9ng k\u1ebb vi\u1ec1n m\u00e0u xanh: L\u00e0 v\u00f9ng\u00a0\u0111\u1eb7t s\u1eb5n gi\u00e1 tr\u1ecb lu\u00f4n hi\u1ec7n\u00a0khi l\u1ecdc<\/p>\n

B\u01b0\u1edbc 3: Record macro\u00a0\u0111\u1ec3 l\u1ea5y c\u00e2u l\u1ec7nh VBA cho vi\u1ec7c L\u1ecdc d\u1eef li\u1ec7u v\u00e0 Thi\u1ebft l\u1eadp ch\u1ebf\u00a0\u0111\u1ed9 xem trang in<\/strong><\/p>\n

Trong tab Developer, b\u1ea5m ch\u1ecdn v\u00e0o ch\u1ee9c n\u0103ng Record macro\u00a0\u0111\u1ec3 ghi l\u1ea1i c\u00e2u l\u1ec7nh cho c\u00e1c thao t\u00e1c:<\/p>\n