Top doanh nghiệp đã đăng ký cho nhân viên

Bạn sẽ học được gì?

Hình thành tư duy lập trình VBA cơ bản giúp giải quyết các vấn đề tận gốc thông qua các bài tập thiết thực trong công việc.
Hiểu cặn kẽ các kiến thức căn bản.
Biết cách tự viết code, đọc hiểu code và sửa code VBA.
Thiết lập một tiện ích tự động xử lý số liệu.
Thay đổi menu Excel, tạo form nhập liệu bằng VBA theo ý muốn.
Viết được các mã lệnh Macro để tự động phân tích, nhập và xử lý số liệu.
Nắm được một số kỹ năng lập trình thông dụng: Phát hiện và xử lý lỗi, tạo Userform, sự kiện, in hàng loạt, thêm/sửa/xóa dữ liệu, nạp dữ liệu, trích xuất dữ liệu...
Ứng dụng nội dung khóa học VBA online vào một số công việc cụ thể trong quản lý nhân sự, kế toán, tài chính, quản lý dự án...

Khoá học này sẽ có:

Video

13h 17m giờ học

Article

3 bài viết chuyên môn

Material

24 tài liệu đính kèm

Exam questions

1 đề thi ghi nhớ kiến thức

Nội dung khoá học

18 Chương . 130 bài giảng . 13h 17m giờ học

1

CHƯƠNG MỞ ĐẦU

2

Tổng quan về VBA

5 bài học thử
3

Cách ghi và sử dụng Macro

3 bài học thử
4

Tìm hiểu về Module trong VBA

1 bài học thử
5

Kỹ thuật viết code trong VBA

2 bài học thử
6

Kỹ thuật khai báo và sử dụng biến trong lập trình VBA

1 bài học thử
7

Cách viết code VBA với đối tượng Range, Cell

1 bài học thử
8

Cách viết code VBA với đối tượng Worksheet

5 bài học thử
9

Cách viết code VBA với đối tượng Workbook

4 bài học thử
10

Các cấu trúc thường gặp trong lập trình VBA

11

Tìm hiểu về vòng lặp trong VBA

12

Các loại lỗi và cách xử lý lỗi khi lập trình

13

Lập trình UserForm cơ bản

2 bài học thử
14

Lập trình sự kiện trong VBA

15

Các bài tập chuyên đề: Ứng dụng VBA trong công việc

16

Kết quả các bài tập chuyên đề: Ứng dụng VBA trong công việc

17

Tài liệu tham khảo - File mẫu sử dụng VBA trong công việc

18

Exam: Đề kiểm tra Kỹ năng Sử dụng VBA

Mô tả khoá học

Từ người mới bắt đầu đến chuyên gia VBA Excel chuẩn Microsoft sau khóa học VBA Excel của Gitiho. 

Hiểu được những khó khăn của việc tự học VBA, trải qua nhiều năm đào tạo hàng ngàn học viên cá nhân và doanh nghiệp, giảng viên Dương Mạnh Quân sẽ cung cấp những bài giảng chi tiết, hướng dẫn từng bước một để học viên có thể thành thạo từng phần, trước khi cung cấp tư duy và phương pháp để xử lý các bài toán tự động hóa công việc, quy trình trên Excel nâng cao

Điều gì tạo nên sự khác biệt để khóa học Tuyệt đỉnh VBA của Gitiho là chương trình học VBA online có nhiều học viên theo học nhất:

  1. Chương trình học chi tiết, đầy đủ với hơn 130 bài giảng và 14+ giờ học VBA.
  2. Dự án + bài tập thực hành chi tiết, đi theo từng chương/phần, giúp người học VBA Excel luôn được thực hành sau khi học.
  3. Ebook, Add-in kèm theo để người học hiểu sức mạnh to lớn của VBA.
  4. Giảng viên hướng dẫn, giải thích từng code chi tiết - luôn hiểu những khó khăn của dân văn phòng học lập trình VBA.
  5. Video chất lượng, luôn cập nhật giao diện, kiến thức mới.

Những kiến thức bạn sẽ thành thạo sau khóa học này:

  • Nắm vững kiến thức nền tảng về VBA.
  • Thành thạo cách sử dụng Macro.
  • Thành thạo viết code với đối tượng Range, Cell.
  • Thành thạo viết code cho Workbook, Worksheet.
  • Lập trình Form.
  • Lập trình sự kiện.
  • Tư duy xử lý các bài toán bằng VBA.
  • Ứng dụng VBA trong công việc thực tế.

Một vài feedback thực tế từ học viên:

“Đây là 1 khóa học VBA rất bổ ích thầy dạy học có kiến thức rất sâu rộng , mình dù là 1 con gà mờ nhưng sau khi học khóa VBA này mình đã học được rất nhiều kỹ năng không chỉ là của vba mà còn các môn học khác, lời cuối cảm ơn công ty và các thầy cô đã cung cấp 1 nội dung học rất bổ ích”

“Bài giảng tuy ngắn gọn nhưng truyền tải được kiến thức trọng tâm. Sự kết hợp giữa clip và giáo trình rất hợp lí, phương thức giảng dạy thực tế với các bài tập mình thấy dễ hiểu và hiệu quả cao. Chắc chắn tôi sẽ đăng kí khóa học VBA2 sau khi tôi hoàn thành các bài tập.”

“Bài giảng kỹ lưỡng, đúng trọng tâm và ứng dụng ngay được. Ban đầu dịch ở nhà chán quá tính học chơi giết thời gian thôi. Cơ mà nó hay với hữu dụng đến bất ngờ. Giờ file excel của mình trông khá gọn gàng, thao tác làm việc cũng dễ chịu hơn, ko phải dụng cái là mất nguyên dòng công thức nữa. Xứng đáng 5 sao.”

“Tôi năm nay cũng 40 tuổi và lần đầu tiếp xúc với VBA, có thể học chậm hơn các bạn trẻ. Nhưng tôi phải nói khóa VBA Excel này rất dễ hiểu, được sự hướng dẫn của các chuyên gia tôi cũng lập được cho mình một phần mềm ứng dụng excel vào việc quản lý công nợ. Sắp tới tôi cũng có kế hoạch tiếp tục học Sql và tạo ribbon quản lý. Tôi hy vọng mình sẽ đạt được thành công hơn nữa. Cảm ơn Gitiho về khóa học VBA rất hay này”

Xem thêm: Tuyệt đỉnh Excel - Trở thành bậc thầy Excel sau 16h

Giảng viên:

G-LEARNING Giảng viên

Trường đào tạo & phát triển kỹ năng ứng dụng tin học văn phòng

G-LEARNING
  • 4.7 điểm đánh giá

  • 496 đánh giá

  • 232,807 học viên

  • 90 khóa học

Khoá học cùng chủ đề

Đánh giá của học viên

4.84 điểm đánh giá . 64 lượt đánh giá

Pham Thanh Tu

Pham Thanh Tu

10:54 30/11/2022

đây là 1 bài học VBA rất bổ ích thầy dạy học có kiến thức rất sâu rộng, mình dù là 1 con gà mờ nhưng sau khi học mình đã học được rất nhiều kỹ năng không chỉ là của vba mà còn các môn học khác, lời cuối cảm ơn công ty và các thầy cô đã cung cấp 1 nội dung học rất bổ ích . thanks .
Nguyễn Quỳnh Hương

Nguyễn Quỳnh Hương

03:46 04/05/2022

khóa học VBA Excel hữu ích, nhiều ứng dụng thực tế, nhiều bài tập ví dụ và thực hành, dễ hiểu, clip đôi khi hơi bị lag nhưng vẫn không sao, nói chung là cảm thấy hữu ích và hiệu quả, đáng tiền, rất hữu dụng cho công việc
Nguyễn Cảnh Thắng

Nguyễn Cảnh Thắng

01:11 30/11/2021

Khóa học VBA online cung cấp kiến thức đầy đủ trình bày logic giúp người học có thể học theo lộ trình mà không phải bỡ ngỡ. Nội dung thì khỏi phải chê vào đâu được, hi vọng sẽ có nhiều khóa học như này nữa. Good

Hỏi đáp khóa học

0 thảo luận

Thảo luận về bài học

11,544 thảo luận

Nguyễn Huyền

Nguyễn Huyền 30 Jan 2023

Xin được nhờ hướng dẫn thêm cách thay đổi 1 số ô nhập liệu khi được cài mặc định ạ. 

Mình có tải file QUẢN LÝ KHO về cập nhật cho kho hàng của Trung tâm. Có 1 số file mặc định số liệu chỉ nhập trong năm 2020. Xin vui lòng chỉ đãn để thay đổi, cập nhật dữ liệu cho 2023 ạ. 

Came ơn thày cô!

Tuấn Ba

Tuấn Ba [Chuyên gia] 31 Jan 2023

Chào bạn phần này bạn phải sử dụng máy tính mới sử dụng được bạn nhé.

{"id":249775,"crm_contact_id":436047,"name":"Nguy\u1ec5n Huy\u1ec1n","email":"Nthuyen2@daihocthudo.edu.vn","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-12-18 06:44:54","confirmation_code":"2e8ddc3c492ff2029c93c4d9a24096eb","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-09-28T15:51:06.000000Z","updated_at":"2023-01-30T11:02:14.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":16065,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_250\/nguyen-huyen.png","link_profile":"https:\/\/gitiho.com\/u\/249775-nguyen-huyen","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Huyền 31 Jan 2023

Cảm ơn thày giáo đã phản hồi thông tin. Mình cũng thao tác trên máy tính mà vẫn gặp khó khăn ạ

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2023-01-31T14:17:09.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1940,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":32.82}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 31 Jan 2023

Bạn cần bỏ datavalication đi là được nếu chưa được bạn liên hệ cskh để gitiho hỗ trợ nhé.

Phạm Ngọc Thắng

Phạm Ngọc Thắng 31 Jan 2023

Mình đã tải các file ở "2. LỘ TRÌNH HỌC TẬP", "4. TÀI LIỆU THỰC HÀNH KHOÁ HỌC", "5. QUÀ TẶNG" rồi nhưng không thấy báo dấu tích xanh. Vậy, xin hỏi bạn phải làm thêm các bước nào để được báo dấu tích màu xanh?

Tuấn Ba

Tuấn Ba [Chuyên gia] 31 Jan 2023

Chào bạn phần này gitiho sẽ báo bộ phận it để kiểm tra lại nhé.

Nguyễn Liễu

Nguyễn Liễu 30 Jan 2023

Trợ giảng Gitiho (Huyền Trang)

Trợ giảng Gitiho (Huyền Trang) 30 Jan 2023

Chào bạn! Lỗi này là do bạn chưa thiết lập cho chạy Macro trên Excel 

{"id":279343,"crm_contact_id":497057,"name":"Nguy\u1ec5n Li\u1ec5u","email":"lieunguyen.hl@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2023-01-17 09:37:42","confirmation_code":"48ade0c45d5c79f37526c2050421a759","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-01-17T02:34:53.000000Z","updated_at":"2023-01-30T09:20:48.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"Hung yen","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0988354647","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":24509,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_279\/nguyen-lieu.png","link_profile":"https:\/\/gitiho.com\/u\/279343-nguyen-lieu","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Liễu 31 Jan 2023

Vậy thiết lập như thế nào vậy c?

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2023-01-31T14:17:09.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1940,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":32.82}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 31 Jan 2023

Bạn liên hệ cskh để được hỗ trợ nhé.

Bằng Mv

Bằng Mv 31 Jan 2023

Tuấn Ba

Tuấn Ba [Chuyên gia] 31 Jan 2023

Chào bạn bạn đổi tên file excel sang không dấu và lưu vào đường dẫn không dấu nhé.

Liên Bùi

Liên Bùi 31 Jan 2023

Chào thầy, em muốn hỏi code để viết thêm chuỗi kí tự trong 1 ô của excel 

dữ liệu đã có sẵn trong ô, ví dụ là “abcd”

em muốn viết thêm thành abcd_1, abcd_2, abcd_3…

em cảm ơn ah

Tuấn Ba

Tuấn Ba [Chuyên gia] 31 Jan 2023

Bạn làm như sau nhé

Option Explicit
Function ThemText(chuoi As String, KyTu As String, Optional So As Double = 0)
   chuoi = chuoi & KyTu
   So = So + 1
   ThemText = chuoi & "" & So
End Function
 

{"id":240456,"crm_contact_id":418320,"name":"Li\u00ean B\u00f9i","email":"lienbt86@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"71d034b0fc3777740bdb921e32e44035","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-08-14T04:03:54.000000Z","updated_at":"2022-10-19T09:07:19.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":1,"birthday":"1996-10-09 00:00:00","position":null,"achievement":null,"full_name":null,"address":"c\u1ea7u gi\u1ea5y","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0904930998","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":33294,"google_id":"114873586400756660287","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_240\/lien-bui.png","link_profile":"https:\/\/gitiho.com\/u\/240456-lien-bui","business_employers":[],"vip_account":null,"roles":[]}

Liên Bùi 31 Jan 2023

cảm ơn thầy ah

Lê Thị Quỳnh

Lê Thị Quỳnh 31 Jan 2023

Em cần gửi phiếu lương dạng pdf cho nhiều người qua email, thầy cho e xin hướng dẫn và file mẫu với ạ

Tuấn Ba

Tuấn Ba [Chuyên gia] 31 Jan 2023

Bạn xem video sau nhé

https://www.youtube.com/watch?v=muqiXVJ0dl0

hoặc sử dụng addins gitiho thì không cần phải dùng vba

Hana Vũ

Hana Vũ 28 Jan 2023

Dương Mạnh Quân

Dương Mạnh Quân [Chuyên gia] 29 Jan 2023

Office của bạn đang đặt chế độ không cho phép macro hoạt động.

Lỗi này có thể xảy ra khi file bạn đang ở chế độ online (đồng bộ trên OneDrive dạng lưu trữ online). VBA chỉ áp dụng khi dùng dưới dạng file offline thôi (file riêng, tải về dùng, không dùng trực tiếp trên web, không đồng bộ trực tiếp). Muốn lưu trữ file có vba thì chỉ upload-download file mỗi khi cần dùng thôi.

Đỗ Khánh Sơn

Đỗ Khánh Sơn 27 Jan 2023

Tải về bị thiếu file và không cài đc ạ.

Tuấn Ba

Tuấn Ba [Chuyên gia] 27 Jan 2023

Bạn liên hệ cskh và hẹn lịch hỗ trợ nhé

Nguyễn Văn Thực

Nguyễn Văn Thực 26 Dec 2022

Thầy ơi
Ô Cells(3,2) khi KHÔNG NHẬP GÌ XÓA ĐI NHƯNG   Sheet6.Range("B3:D3").value vẫn có giá trị ạ

E gửi Thầy file đây ạ Thầy chỉ giúp e ạ
Private Sub Worksheet_Change(ByVal Target As Range)
   Dim i As Long
   Dim j As Long
   Dim lr As Long

   With Sheet5
        lr = .Range("B" & Rows.Count).End(xlUp).Row
        i = 3
            For i = 3 To lr
                   If Not Application.Intersect(Target, .Cells(i, 2)) Is Nothing Then
                        If .Cells(i, 2) <> "" Then
                  
                            Sheet6.Cells(i, 2).Value = WorksheetFunction.VLookup(.Cells(i, 2), .Range("B3:D10"), 1, 0)
                            Sheet6.Cells(i, 3).Value = WorksheetFunction.VLookup(.Cells(i, 2), .Range("B3:D10"), 2, 0)
                            Sheet6.Cells(i, 4).Value = WorksheetFunction.VLookup(.Cells(i, 2), .Range("B3:D10"), 3, 0)
                           
                        Else
                          
                            Sheet6.Range("B3:D10").clear
                          
                       End If
                                        
                   End If
         
             Next i
        
     
   End With
   
End Sub

Nguyễn Văn Thực

Nguyễn Văn Thực 26 Dec 2022

NoIDNamePhòng
1 Mr ACS
2 Mr BOQC
3 Mr ACS
4 Mr BOQC
5 Mr ACS
6 Mr BOQC
7 Mr ACS
8 Mr BOQC
NoIDNamePhòng
 1Mr ACS
    
    
    
    
    
    
    

 

{"id":190152,"crm_contact_id":325299,"name":"Nguy\u1ec5n V\u0103n Th\u1ef1c","email":"nvt2810@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ffcb5861edb1b81ed1112d8531d39d8e","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-18T02:02:49.000000Z","updated_at":"2022-02-23T15:20:03.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"Ph\u1ea1m V\u0103n \u0110\u1ed3ng-C\u1ed5 Nhu\u1ebf1-B\u1eafc T\u1eeb Li\u00eam-H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0965547864","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":30358,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_190\/nguyen-thuc.png","link_profile":"https:\/\/gitiho.com\/u\/190152-nguyen-van-thuc","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Văn Thực 26 Dec 2022

E chưa biết đính kèm tải file lên chỗ nào ạ

{"id":190152,"crm_contact_id":325299,"name":"Nguy\u1ec5n V\u0103n Th\u1ef1c","email":"nvt2810@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ffcb5861edb1b81ed1112d8531d39d8e","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-18T02:02:49.000000Z","updated_at":"2022-02-23T15:20:03.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"Ph\u1ea1m V\u0103n \u0110\u1ed3ng-C\u1ed5 Nhu\u1ebf1-B\u1eafc T\u1eeb Li\u00eam-H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0965547864","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":30358,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_190\/nguyen-thuc.png","link_profile":"https:\/\/gitiho.com\/u\/190152-nguyen-van-thuc","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Văn Thực 26 Dec 2022

Từ ô B3~B9 khi e xóa data đi data bên sheet6 cũng xóa từ  B3~B9.

 

 

Chỉ còn ô cuối ví dụ ở đây là ô B10 nếu ko có data thì sự kiện change nó ko thực hiện

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2023-01-31T14:17:09.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1940,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":32.82}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 26 Dec 2022

Bạn gửi file lên google drive rồi cho gitiho xin link truy cập nhé.

{"id":190152,"crm_contact_id":325299,"name":"Nguy\u1ec5n V\u0103n Th\u1ef1c","email":"nvt2810@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ffcb5861edb1b81ed1112d8531d39d8e","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-18T02:02:49.000000Z","updated_at":"2022-02-23T15:20:03.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"Ph\u1ea1m V\u0103n \u0110\u1ed3ng-C\u1ed5 Nhu\u1ebf1-B\u1eafc T\u1eeb Li\u00eam-H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0965547864","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":30358,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_190\/nguyen-thuc.png","link_profile":"https:\/\/gitiho.com\/u\/190152-nguyen-van-thuc","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Văn Thực 26 Dec 2022

E gửi Thầy Link Diver:https://docs.google.com/spreadsheets/d/1yqQQz-uStpICoeXOBJZvisBRYibFlTj6/edit#gid=966059976

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2023-01-31T14:17:09.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1940,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":32.82}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 26 Dec 2022

Bạn cho gitiho xin quyền truy cập nhé.

{"id":190152,"crm_contact_id":325299,"name":"Nguy\u1ec5n V\u0103n Th\u1ef1c","email":"nvt2810@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ffcb5861edb1b81ed1112d8531d39d8e","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-18T02:02:49.000000Z","updated_at":"2022-02-23T15:20:03.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"Ph\u1ea1m V\u0103n \u0110\u1ed3ng-C\u1ed5 Nhu\u1ebf1-B\u1eafc T\u1eeb Li\u00eam-H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0965547864","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":30358,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_190\/nguyen-thuc.png","link_profile":"https:\/\/gitiho.com\/u\/190152-nguyen-van-thuc","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Văn Thực 27 Dec 2022

E chuyển chế độ mọi người đều có thể truy cập và chỉnh sửa rồi Thầy xem thử có vào được ko ạ.

{"id":190152,"crm_contact_id":325299,"name":"Nguy\u1ec5n V\u0103n Th\u1ef1c","email":"nvt2810@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ffcb5861edb1b81ed1112d8531d39d8e","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-18T02:02:49.000000Z","updated_at":"2022-02-23T15:20:03.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"Ph\u1ea1m V\u0103n \u0110\u1ed3ng-C\u1ed5 Nhu\u1ebf1-B\u1eafc T\u1eeb Li\u00eam-H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0965547864","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":30358,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_190\/nguyen-thuc.png","link_profile":"https:\/\/gitiho.com\/u\/190152-nguyen-van-thuc","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Văn Thực 27 Dec 2022

E share cả quyền  vào email của Trung Tâm rồi ạ:hotro@gitiho.com

{"id":190152,"crm_contact_id":325299,"name":"Nguy\u1ec5n V\u0103n Th\u1ef1c","email":"nvt2810@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ffcb5861edb1b81ed1112d8531d39d8e","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-18T02:02:49.000000Z","updated_at":"2022-02-23T15:20:03.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"Ph\u1ea1m V\u0103n \u0110\u1ed3ng-C\u1ed5 Nhu\u1ebf1-B\u1eafc T\u1eeb Li\u00eam-H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0965547864","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":30358,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_190\/nguyen-thuc.png","link_profile":"https:\/\/gitiho.com\/u\/190152-nguyen-van-thuc","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Văn Thực 27 Dec 2022

E gửi lại Thầy Link => e để chế độ mọi người đều có thể chỉnh sửa:
https://docs.google.com/spreadsheets/d/1yqQQz-uStpICoeXOBJZvisBRYibFlTj6/edit?usp=sharing&ouid=100650265315982044903&rtpof=true&sd=true

{"id":66,"crm_contact_id":127658,"name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","email":"duongquan211287@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2018-11-06 21:53:37","confirmation_code":"d79b40591d95db0a31320b960a8a115c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2017-05-10T03:17:27.000000Z","updated_at":"2023-01-31T14:37:06.000000Z","deleted_at":null,"unit_name":"Gitiho.com","grade":0,"avatar_disk":"public","avatar_path":"users\/1657593507.jpg","gender":0,"birthday":"1987-12-20 07:00:00","position":"Chuy\u00ean gia excel","achievement":null,"full_name":"D\u01b0\u01a1ng Qu\u00e2n","address":"Gitiho.com","status_text":"<p>Gi\u1ea3ng vi\u00ean: D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n<\/p><p>- N\u01a1i c\u00f4ng t\u00e1c hi\u1ec7n t\u1ea1i: Chuy\u00ean gia gi\u00e1o d\u1ee5c t\u1ea1i Gitiho.com<\/p><p><span style=\"color: rgb(0, 0, 0);\">- T\u1eebng l\u00e0m k\u1ebf to\u00e1n qu\u1ea3n tr\u1ecb t\u1ea1i c\u00f4ng ty TNHH DTK'Vina, tr\u1ef1c thu\u1ed9c t\u1eadp&nbsp;\u0111o\u00e0n DEAHO, H\u00e0n Qu\u1ed1c.<\/span><br><\/p><p>- H\u01a1n 7 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi&nbsp;excel trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh<\/p><p>- X\u00e2y d\u1ef1ng nhi\u1ec1u ph\u1ea7n m\u1ec1m&nbsp;excel trong c\u00e1c l\u0129nh v\u1ef1c: K\u1ebf to\u00e1n kho, k\u1ebf to\u00e1n c\u00f4ng n\u1ee3, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng... trong nhi\u1ec1u lo\u1ea1i h\u00ecnh doanh nghi\u1ec7p kh\u00e1c nhau.<\/p><p>- X\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m&nbsp;excel trong l\u0129nh v\u1ef1c t\u00e0i ch\u00ednh: l\u1eadp ph\u01b0\u01a1ng&nbsp;\u00e1n kinh doanh, qu\u1ea3n tr\u1ecb d\u00f2ng ti\u1ec1n trong doanh nghi\u1ec7p...<\/p><p>- T\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p ho\u00e0n thi\u1ec7n quy tr\u00ecnh qu\u1ea3n l\u00fd doanh nghi\u1ec7p,&nbsp;\u00e1p d\u1ee5ng ph\u1ea7n m\u1ec1m&nbsp;excel n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c.<\/p><p><br><\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977705162","become_teacher":0,"primary_wallet":54168591,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"103589301897268320461","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1458,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_number":"2022\/GITIHO-DUONGQUAN","contract_date":"2019-12-31T17:00:00.000000Z","contract_delegate":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_address":"24 ng\u00e1ch 9 ng\u00f5 162A T\u00f4n \u0110\u1ee9c Th\u1eafng, \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i","contract_account_number":"19033577541015","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657593507.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/66-duong-manh-quan","business_employers":[{"id":33,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":15.12}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":8,"model_type":"App\\Models\\User"}},{"id":15,"name":"BlogManager","display_name":"BlogManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":15,"model_type":"App\\Models\\User"}},{"id":17,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":17,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":19,"model_type":"App\\Models\\User"}}]}

Dương Mạnh Quân [Chuyên gia] 27 Dec 2022

Bạn đang lập trình cho sự kiện Worksheet_change trong sheet5.

Theo mình thấy câu lệnh For cần đặt trong đoạn IF giới hạn nơi diễn ra sự kiện (điều chỉnh lại thứ tự này).

Hàm VLOOKUP bạn viết cũng chưa đúng. Cột nhận kết quả phải luôn lớn hơn 1 nhé (dòng vlookup đầu tiên bị sai).

{"id":190152,"crm_contact_id":325299,"name":"Nguy\u1ec5n V\u0103n Th\u1ef1c","email":"nvt2810@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ffcb5861edb1b81ed1112d8531d39d8e","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-18T02:02:49.000000Z","updated_at":"2022-02-23T15:20:03.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"Ph\u1ea1m V\u0103n \u0110\u1ed3ng-C\u1ed5 Nhu\u1ebf1-B\u1eafc T\u1eeb Li\u00eam-H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0965547864","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":30358,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_190\/nguyen-thuc.png","link_profile":"https:\/\/gitiho.com\/u\/190152-nguyen-van-thuc","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Văn Thực 27 Dec 2022

E cảm ơn Thầy!

{"id":190152,"crm_contact_id":325299,"name":"Nguy\u1ec5n V\u0103n Th\u1ef1c","email":"nvt2810@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"ffcb5861edb1b81ed1112d8531d39d8e","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-12-18T02:02:49.000000Z","updated_at":"2022-02-23T15:20:03.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":"Ph\u1ea1m V\u0103n \u0110\u1ed3ng-C\u1ed5 Nhu\u1ebf1-B\u1eafc T\u1eeb Li\u00eam-H\u00e0 N\u1ed9i","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0965547864","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":30358,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_190\/nguyen-thuc.png","link_profile":"https:\/\/gitiho.com\/u\/190152-nguyen-van-thuc","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Văn Thực 19 Jan 2023

Thầy ơi

Ứng dụng MẢNG rất hay.
Nhưng khó => chúng e chưa hiểu.
Thầy làm thêm các bài giảng về MẢNG ạ.

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2023-01-31T14:17:09.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1940,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":32.82}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 20 Jan 2023

Bạn xem trong khóa vbag02 nhé 

Ngô Thị Kim Chung

Ngô Thị Kim Chung 16 Jan 2023

Kính gừi thầy! laftop của em: bấm F4 không cố định ô bằng dấu $, vậy bấm phím nào để cố định ô vậy ?
Tuấn Ba

Tuấn Ba [Chuyên gia] 17 Jan 2023

Chào bạn bạn bấm Fn+F4 nhé.

dieuanh199952@gmail.com

dieuanh199952@gmail.com 15 Jan 2023

Thầy có thể xem cho em viết sai đoạn code ở chỗ nào được ko ạ mà em cứ bị bắt sai ở chỗ này

Sheets("PhieuLuong").Range("F6").Value = Sheets("Data_TienLuong").Range("E" & i).Value

Tuấn Ba

Tuấn Ba [Chuyên gia] 15 Jan 2023

Bạn đẩy file lên giúp gitiho bạn nhé.

{"id":66,"crm_contact_id":127658,"name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","email":"duongquan211287@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2018-11-06 21:53:37","confirmation_code":"d79b40591d95db0a31320b960a8a115c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2017-05-10T03:17:27.000000Z","updated_at":"2023-01-31T14:37:06.000000Z","deleted_at":null,"unit_name":"Gitiho.com","grade":0,"avatar_disk":"public","avatar_path":"users\/1657593507.jpg","gender":0,"birthday":"1987-12-20 07:00:00","position":"Chuy\u00ean gia excel","achievement":null,"full_name":"D\u01b0\u01a1ng Qu\u00e2n","address":"Gitiho.com","status_text":"<p>Gi\u1ea3ng vi\u00ean: D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n<\/p><p>- N\u01a1i c\u00f4ng t\u00e1c hi\u1ec7n t\u1ea1i: Chuy\u00ean gia gi\u00e1o d\u1ee5c t\u1ea1i Gitiho.com<\/p><p><span style=\"color: rgb(0, 0, 0);\">- T\u1eebng l\u00e0m k\u1ebf to\u00e1n qu\u1ea3n tr\u1ecb t\u1ea1i c\u00f4ng ty TNHH DTK'Vina, tr\u1ef1c thu\u1ed9c t\u1eadp&nbsp;\u0111o\u00e0n DEAHO, H\u00e0n Qu\u1ed1c.<\/span><br><\/p><p>- H\u01a1n 7 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi&nbsp;excel trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh<\/p><p>- X\u00e2y d\u1ef1ng nhi\u1ec1u ph\u1ea7n m\u1ec1m&nbsp;excel trong c\u00e1c l\u0129nh v\u1ef1c: K\u1ebf to\u00e1n kho, k\u1ebf to\u00e1n c\u00f4ng n\u1ee3, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng... trong nhi\u1ec1u lo\u1ea1i h\u00ecnh doanh nghi\u1ec7p kh\u00e1c nhau.<\/p><p>- X\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m&nbsp;excel trong l\u0129nh v\u1ef1c t\u00e0i ch\u00ednh: l\u1eadp ph\u01b0\u01a1ng&nbsp;\u00e1n kinh doanh, qu\u1ea3n tr\u1ecb d\u00f2ng ti\u1ec1n trong doanh nghi\u1ec7p...<\/p><p>- T\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p ho\u00e0n thi\u1ec7n quy tr\u00ecnh qu\u1ea3n l\u00fd doanh nghi\u1ec7p,&nbsp;\u00e1p d\u1ee5ng ph\u1ea7n m\u1ec1m&nbsp;excel n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c.<\/p><p><br><\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977705162","become_teacher":0,"primary_wallet":54168591,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"103589301897268320461","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1458,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_number":"2022\/GITIHO-DUONGQUAN","contract_date":"2019-12-31T17:00:00.000000Z","contract_delegate":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_address":"24 ng\u00e1ch 9 ng\u00f5 162A T\u00f4n \u0110\u1ee9c Th\u1eafng, \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i","contract_account_number":"19033577541015","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657593507.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/66-duong-manh-quan","business_employers":[{"id":33,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":15.12}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":8,"model_type":"App\\Models\\User"}},{"id":15,"name":"BlogManager","display_name":"BlogManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":15,"model_type":"App\\Models\\User"}},{"id":17,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":17,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":19,"model_type":"App\\Models\\User"}}]}

Dương Mạnh Quân [Chuyên gia] 16 Jan 2023

Bạn thử kiểm tra lại:

  • Giá trị Dòng đầu và dòng cuối: dòng cuối phải lớn hơn dòng đầu.
  • Dấu nháy kép khi viết tên sheet, tên tọa độ trong range cần sử dụng đúng là dấu nháy kép nhé.

Rồi bạn có thể bấm phím f8 để kiểm tra từng dòng code xem cụ thể lỗi ở đâu.

dieuanh199952@gmail.com

dieuanh199952@gmail.com 13 Jan 2023

Em không thể nào mở được userform sau khi dán macro vào shape

dieuanh199952@gmail.com

dieuanh199952@gmail.com 13 Jan 2023

nó chỉ ra đoạn vàng này nhưng e không rõ sai ở đâu ạ

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2023-01-31T14:17:09.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1940,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":32.82}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 13 Jan 2023

bạn đẩy file lên giúp gitiho nhé

{"id":251122,"crm_contact_id":438548,"name":"dieuanh199952@gmail.com","email":"dieuanh199952@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-10-17 15:37:00","confirmation_code":"d59c90903d9e55582829c1a663b7ecde","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-10-04T07:26:19.000000Z","updated_at":"2023-01-13T09:20:20.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":"dieuanh199952@gmail.com","address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":29449,"google_id":"117127447706941968677","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_251\/dieuanh199952-at-gmailcom-dieuanh199952-at-gmailcom.png","link_profile":"https:\/\/gitiho.com\/u\/251122-dieuanh199952-at-gmailcom","business_employers":[],"vip_account":null,"roles":[]}

dieuanh199952@gmail.com 13 Jan 2023

Private Sub Cmb_Dong_Click()
Unload Me
End Sub

Private Sub Cmb_Luu_Click()
Dim DongCuoi As Long
DongCuoi = Sheets("Sheet1").Range("G" & Rows.Count).End(xlUp).Row
With Sheets("Sheet1")
.Range("G" & DongCuoi + 1) = Tb_HoTen
.Range("H" & DongCuoi + 1) = CDate(Tb_NgaySinh)
.Range("I" & DongCuoi + 1) = Cb_BoPhan
.Range("J" & DongCuoi + 1) = Tb_SoNgayCong
.Range("K" & DongCuoi + 1) = Tb_MucLuong
.Range("K" & DongCuoi + 1) = Tb_TienLuong

End With

End Sub

Private Sub Tb_HoTen_Change()
Tb_HoTen = StrConv(Tb_HoTen, vbProperCase)
End Sub
Private Sub Tb_MucLuong_Change()
Tb_MucLuong = Format(Tb_MucLuong, "#,##0")
If Tb_MucLuong <> "" And Tb_NgayCong <> "" Then
Tb_TienLuong = Tb_NgayCong * Tb_MucLuong
End If
End Sub

Private Sub Tb_NgayCong_Change()
If Tb_NgayCong <> "" And Tb_MucLuong <> "" Then
Tb_TienLuong = Tb_NgayCong * Tb_MucLuong
End If
End Sub
Private Sub Tb_NgaySinh_AfterUpdate()
Tb_NgaySinh = Format(Tb_NgaySinh, "dd/mm/yyyy")
End Sub
Private Sub UserForm_Initialize()
Dim ChonTen As Object
For Each ChonTen In Sheets("Sheet1").Range("Bo_Phan")
Cb_BoPhan.AddItem ChonTen
Next
End Sub

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2023-01-31T14:17:09.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1940,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":32.82}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 13 Jan 2023

Bạn đẩy file lên gitiho mới dubug dc bạn nhé

{"id":251122,"crm_contact_id":438548,"name":"dieuanh199952@gmail.com","email":"dieuanh199952@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-10-17 15:37:00","confirmation_code":"d59c90903d9e55582829c1a663b7ecde","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-10-04T07:26:19.000000Z","updated_at":"2023-01-13T09:20:20.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":"dieuanh199952@gmail.com","address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":29449,"google_id":"117127447706941968677","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_251\/dieuanh199952-at-gmailcom-dieuanh199952-at-gmailcom.png","link_profile":"https:\/\/gitiho.com\/u\/251122-dieuanh199952-at-gmailcom","business_employers":[],"vip_account":null,"roles":[]}

dieuanh199952@gmail.com 13 Jan 2023

mình đẩy file như thế nào ạ

 

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2023-01-31T14:17:09.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1940,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":32.82}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 14 Jan 2023

Chào bạn bạn đẩy file lên google drive rồi cho gitiho xin link truy cập nhé.

Dương Tấn Phước

Dương Tấn Phước 11 Jan 2023

Tuấn Ba

Tuấn Ba [Chuyên gia] 11 Jan 2023

bạn kích chuột phải  vào khung đó và làm như hình

dieuanh199952@gmail.com

dieuanh199952@gmail.com 10 Jan 2023

Em đang thử luyện tập sử dụng vòng lặp để gộp dữ liệu từ nhiều file nhưng mà không hiểu sao khi chạy lại không tìm thấy file để chọn ạ?

dieuanh199952@gmail.com

dieuanh199952@gmail.com 10 Jan 2023

mà rõ ràng em đã gộp các workbook về một folder rồi ạ

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2023-01-31T14:17:09.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":1010070,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"118095757772556445137","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1940,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":32.82}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"Qu\u1ea3n l\u00fd n\u1ed9i dung","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-12-21T08:27:44.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 11 Jan 2023

Chào bạn bạn có thể đẩy code lên được không hoặc xem file này

https://drive.google.com/file/d/1ZfKQQa91N-mIoUsupoiT3ibxjDNAzerv/view?usp=sharing

{"id":251122,"crm_contact_id":438548,"name":"dieuanh199952@gmail.com","email":"dieuanh199952@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-10-17 15:37:00","confirmation_code":"d59c90903d9e55582829c1a663b7ecde","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-10-04T07:26:19.000000Z","updated_at":"2023-01-13T09:20:20.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":"dieuanh199952@gmail.com","address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":29449,"google_id":"117127447706941968677","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_251\/dieuanh199952-at-gmailcom-dieuanh199952-at-gmailcom.png","link_profile":"https:\/\/gitiho.com\/u\/251122-dieuanh199952-at-gmailcom","business_employers":[],"vip_account":null,"roles":[]}

dieuanh199952@gmail.com 11 Jan 2023

Code là phần phía bên tay phải hình ảnh ấy ạ

{"id":251122,"crm_contact_id":438548,"name":"dieuanh199952@gmail.com","email":"dieuanh199952@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-10-17 15:37:00","confirmation_code":"d59c90903d9e55582829c1a663b7ecde","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-10-04T07:26:19.000000Z","updated_at":"2023-01-13T09:20:20.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":"dieuanh199952@gmail.com","address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":29449,"google_id":"117127447706941968677","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_251\/dieuanh199952-at-gmailcom-dieuanh199952-at-gmailcom.png","link_profile":"https:\/\/gitiho.com\/u\/251122-dieuanh199952-at-gmailcom","business_employers":[],"vip_account":null,"roles":[]}

dieuanh199952@gmail.com 11 Jan 2023

Sub Gop_File01()
'Hien thi cua so de minh chon fil
With Application.FileDialog(msoFileDialogFolderPicker)
.AllowMultiSelect = True
.Show
Dim i As Integer
For i = 1 To .SelectedItems.Count
Dim wb_KQ As Workbook
Dim wb_file_01 As Workbook
Set wb_KQ = ThisWorkbook
Set wb_file_01 = Workbooks.Open(.SelectedItems(i))

Dim DongCuoi_KQ As Long
DongCuoi_KQ = ThisWorkbook.Sheets("Data_TiengLuong").Range("A" & Rows.Count).End(xlUp).Row
Dim DongDau As Long
DongDau = 8
Dim DongCuoi As Long
DongCuoi = wb_file_01.Sheets(1).Range("A" & Rows.Count).End(xlUp).Row
Dim Khoang_cach As Long
Khoang_cach = DongCuoi - DongDau + 1

wb_KQ.Range("A" & DongCuoi_KQ + 1 & ":BM" & DongCuoi_KQ + KhoangCach).Value _
= wb_file_01.Sheets(1).Range("A" & DongDau & ":BM" & DongCuoi).Value
MsgBox "Nhap Du Lieu Thanh Cong"
Next i
End With
End Sub

{"id":66,"crm_contact_id":127658,"name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","email":"duongquan211287@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2018-11-06 21:53:37","confirmation_code":"d79b40591d95db0a31320b960a8a115c","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2017-05-10T03:17:27.000000Z","updated_at":"2023-01-31T14:37:06.000000Z","deleted_at":null,"unit_name":"Gitiho.com","grade":0,"avatar_disk":"public","avatar_path":"users\/1657593507.jpg","gender":0,"birthday":"1987-12-20 07:00:00","position":"Chuy\u00ean gia excel","achievement":null,"full_name":"D\u01b0\u01a1ng Qu\u00e2n","address":"Gitiho.com","status_text":"<p>Gi\u1ea3ng vi\u00ean: D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n<\/p><p>- N\u01a1i c\u00f4ng t\u00e1c hi\u1ec7n t\u1ea1i: Chuy\u00ean gia gi\u00e1o d\u1ee5c t\u1ea1i Gitiho.com<\/p><p><span style=\"color: rgb(0, 0, 0);\">- T\u1eebng l\u00e0m k\u1ebf to\u00e1n qu\u1ea3n tr\u1ecb t\u1ea1i c\u00f4ng ty TNHH DTK'Vina, tr\u1ef1c thu\u1ed9c t\u1eadp&nbsp;\u0111o\u00e0n DEAHO, H\u00e0n Qu\u1ed1c.<\/span><br><\/p><p>- H\u01a1n 7 n\u0103m kinh nghi\u1ec7m l\u00e0m vi\u1ec7c v\u1edbi&nbsp;excel trong l\u0129nh v\u1ef1c k\u1ebf to\u00e1n, t\u00e0i ch\u00ednh<\/p><p>- X\u00e2y d\u1ef1ng nhi\u1ec1u ph\u1ea7n m\u1ec1m&nbsp;excel trong c\u00e1c l\u0129nh v\u1ef1c: K\u1ebf to\u00e1n kho, k\u1ebf to\u00e1n c\u00f4ng n\u1ee3, k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng... trong nhi\u1ec1u lo\u1ea1i h\u00ecnh doanh nghi\u1ec7p kh\u00e1c nhau.<\/p><p>- X\u00e2y d\u1ef1ng ph\u1ea7n m\u1ec1m&nbsp;excel trong l\u0129nh v\u1ef1c t\u00e0i ch\u00ednh: l\u1eadp ph\u01b0\u01a1ng&nbsp;\u00e1n kinh doanh, qu\u1ea3n tr\u1ecb d\u00f2ng ti\u1ec1n trong doanh nghi\u1ec7p...<\/p><p>- T\u01b0 v\u1ea5n gi\u1ea3i ph\u00e1p ho\u00e0n thi\u1ec7n quy tr\u00ecnh qu\u1ea3n l\u00fd doanh nghi\u1ec7p,&nbsp;\u00e1p d\u1ee5ng ph\u1ea7n m\u1ec1m&nbsp;excel n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c.<\/p><p><br><\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0977705162","become_teacher":0,"primary_wallet":54168591,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"103589301897268320461","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1458,"email_invalid":0,"type_email_invalid":null,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_number":"2022\/GITIHO-DUONGQUAN","contract_date":"2019-12-31T17:00:00.000000Z","contract_delegate":"D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n","contract_address":"24 ng\u00e1ch 9 ng\u00f5 162A T\u00f4n \u0110\u1ee9c Th\u1eafng, \u0110\u1ed1ng \u0110a, H\u00e0 N\u1ed9i","contract_account_number":"19033577541015","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1657593507.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/66-duong-manh-quan","business_employers":[{"id":33,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","bizUser":"","avgCompleted":15.12}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":8,"model_type":"App\\Models\\User"}},{"id":15,"name":"BlogManager","display_name":"BlogManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":15,"model_type":"App\\Models\\User"}},{"id":17,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":17,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":66,"role_id":19,"model_type":"App\\Models\\User"}}]}

Dương Mạnh Quân [Chuyên gia] 11 Jan 2023

Bạn đang viết code theo: Application.FileDialog(msoFileDialogFolderPicker) tức là chọn folder, không phải chọn file.

Bạn viết theo FilePicker nhé.

Phan Quỳnh Thương

Phan Quỳnh Thương 11 Jan 2023

Thầy cho e hỏi với cách xác định dòng cuối để tìm dòng định dạng, thì viết dòng cuối + 1 như thế nào là đúng ạ?
E viết như sau ko chạy được ?
Sub Dongtongcong_vietlai()
Dim Dongcuoi As Long
Dongcuoi = Sheets("sheet2").Range("B" & Rows.Count).End(xlUp).Row
Range("Dongcuoi" + 1).Style = "Total"
End Sub

Dương Mạnh Quân

Dương Mạnh Quân [Chuyên gia] 11 Jan 2023

Biến dòng cuối ở dạng Long tức là 1 con số.

Dongcuoi + 1 cũng là 1 con số, thể hiện số dòng.

Khi viết Range phải xác định cả cột và dòng. Do đó code định dạng ở cuối sẽ viết dạng:

Range("A" & dongcuoi + 1 & “:H” & dongcuoi + 1).Style = “Total”

bạn đổi lại tên cột A, H tùy theo thực tế nhé.

VBAG01: Tuyệt đỉnh VBA - Viết code trong tầm tay
4.84

(64 đánh giá)

16,084 học viên
499,000đ
@ 2020 - Bản quyền của Công ty cổ phần công nghệ giáo dục Gitiho Việt Nam
Giấy chứng nhận Đăng ký doanh nghiệp số: 0109077145, cấp bởi Sở kế hoạch và đầu tư TP. Hà Nội
/