Menu

Tất cả danh mục

Đăng ký/ Đăng nhập

Gitiho contest

Cùng gitiho contest chinh phục kiến thức, khẳng định bản thân với hệ thống bài test phong phú, đầy đủ các chủ đề để bạn khám phá.

Chương trình hội viên Gitiho

Gói Hội viên Gitiho: Trọn bộ khoá học theo Khung năng lực

480+ khóa học

15 Danh mục theo kỹ năng, ngành nghề

Năng lực Lõi, Năng lực Chuyên môn, Năng lực Bổ trợ, Năng lực Quản lý

Khám phá ngay

2000+ đã đăng ký

Gói Hội viên G-Skills: 03 kỹ năng bổ trợ thiết yếu

83 khóa học Tin học văn phòng

85 khóa học Kỹ năng mềm

29 khóa học Ngoại ngữ

Khám phá ngay

500+ đã đăng ký

Gitiho for leading business

Tối ưu và đơn giản hóa hoạt động đào tạo tại doanh nghiệp. Sẵn sàng nền tảng, nội dung đào tạo cho tất cả các vị trí, bộ phận. Ứng dụng MIỄN PHÍ ngay vào doanh nghiệp chỉ với MỘT click.

Đã được tin tưởng sử dụng bởi các doanh nghiệp

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

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

1 sách ebook về thư viện code mẫu VBA được biên soạn bởi Gitiho

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

Video

0h 00m giờ học

Article

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

Material

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

Exam questions

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

Nội dung khoá học

0 Chương . 2 bài giảng . 0h 00m giờ học

Mở rộng tất cả các phần
  • 1. Tải ebook thư viện code mẫu VBA
  • 2. Tham gia nhóm học tập trên Facebook

Mô tả khoá học

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

1/5

1 Đánh giá và nhận xét

  • 0%

  • 0%

  • 0%

  • 0%

  • 100%

Tran Thi Ngoc Han

Tran Thi Ngoc Han

code co ban, khong the ap dung vao cong viec ngay nhu gioi thieu.. Thieu hinh anh truc quan, neu la nguoi moi hoc, chua biet gi ve vba se kho hieu, kho hinh dung dan den viec kho ap dung ngay neu can.

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.3 điểm đánh giá

  • 758 đánh giá

  • 290,053 học viên

  • 99 khóa học

Học viên cũng mua

VBAG03 (Nâng cao) - Code mẫu và các chuyên đề ứng dụng VBA
Tổng số 9 giờ 43 bài giảng
5
165
499,000 đ
899,000 đ
VBAG03 (Nâng cao) - Code mẫu và các chuyên đề ứng dụng VBA
THVP02 - Sử dụng máy tính hiệu quả cho dân Văn phòng
Tổng số 6 giờ 73 bài giảng
0
83
399,000 đ
499,000 đ
THVP02 - Sử dụng máy tính hiệu quả cho dân Văn phòng
Làm chủ công cụ Microsoft Access từ A-Z
Tổng số 5 giờ 55 bài giảng
0
70
499,000 đ
799,000 đ
Làm chủ công cụ Microsoft Access từ A-Z
VBAG04 - Ứng dụng VBA trong công việc quản lý kho cửa hàng
Tổng số 21 giờ 151 bài giảng
0
51
499,000 đ
499,000 đ
VBAG04 - Ứng dụng VBA trong công việc quản lý kho cửa hàng
MOS Excel 2016
Tổng số 12 giờ 64 bài giảng
0
35
499,000 đ
699,000 đ
MOS Excel 2016
Quản trị cơ sở dữ liệu với Microsoft SQL Server
Tổng số 3 giờ 26 bài giảng
2
13
499,000 đ
799,000 đ
Quản trị cơ sở dữ liệu với Microsoft SQL Server
Chinh phục kỳ thi công chức, viên chức, thăng hạng - nâng ngạch môn Tin học
Tổng số 11 giờ 51 bài giảng
0
10
499,000 đ
799,000 đ
Chinh phục kỳ thi công chức, viên chức, thăng hạng - nâng ngạch môn Tin học
Kỹ năng sử dụng Trình duyệt Web hiệu quả cho công việc
Tổng số 1 giờ 6 bài giảng
0
7
99,000 đ
199,000 đ
Kỹ năng sử dụng Trình duyệt Web hiệu quả cho công việc
Kiến thức cơ bản về MacOS
Tổng số 1 giờ 9 bài giảng
0
5
299,000 đ
499,000 đ
Kiến thức cơ bản về MacOS
Sử dụng Windows 10 thành thạo cho công việc trong 2h
Tổng số 2 giờ 35 bài giảng
0
5
199,000 đ
299,000 đ
Sử dụng Windows 10 thành thạo cho công việc trong 2h

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

0 thảo luận

Gửi ảnh
Quy định đăng bình luận
Gửi ảnh
Quy định đăng bình luận

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

25 thảo luận

Phung Minh Tuan

Phung Minh Tuan 15 Aug 2023

CHào anh/chị,

Mình chạy code mẫu Sub Insert_Picture_Autofit() nhưng bị lỗi như hình. Vui lòng hướng dẫn mình cách sửa lỗi này?

Cám ơn anh/chị,

 
CSKH Gitiho Việt Nam

CSKH Gitiho Việt Nam 25 Aug 2023

Dạ bạn thử sửa .ShapeRange.LockAspectRatio = msoFalseLeft => .ShapeRange.LockAspectRatio = msoFalse thôi xem sao ạ 
{"id":343891,"crm_contact_id":600266,"name":"L\u00ea Minh Thu\u1ef3 Ph\u01b0\u1ee3ng","email":"leephuong1402@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"2d735fdce1f4f7e7f12f3816e3a4b7f6","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-15T07:32:51.000000Z","updated_at":"2023-08-14T06:27:06.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":"0933906468","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":20437,"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":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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_344\/le-phuong.png","link_profile":"https:\/\/gitiho.com\/u\/343891-le-minh-thuy-phuong","business_employers":[],"vip_account":null,"roles":[]}

Lê Minh Thuỳ Phượng 29 Aug 2023

Báo lỗi như zậy là sao ạ. Anh chị giúp em ạ. Em cám ơn
{"id":82548,"crm_contact_id":29934,"name":"CSKH Gitiho Vi\u1ec7t Nam","email":"hotro@gitiho.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-02-12 17:12:54","confirmation_code":"ccae872502b90d64fa68a5773858a513","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-01-30T15:32:47.000000Z","updated_at":"2023-09-18T12:57:58.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1652762083.png","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"CSKH Gitiho Vi\u1ec7t Nam","address":"Gitiho Vi\u1ec7t Nam","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0774116285","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":8000,"google_id":"109213028097135238411","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":32,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1652762083.png","link_profile":"https:\/\/gitiho.com\/u\/82548-cskh-gitiho-viet-nam","business_employers":[{"id":2713,"biz_business_id":79,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0},{"id":2715,"biz_business_id":12,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0},{"id":2716,"biz_business_id":61,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0}],"vip_account":null,"roles":[{"id":10,"biz_business_id":0,"name":"CourseManager","display_name":"CourseManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":10,"model_type":"App\\Models\\User"}},{"id":11,"biz_business_id":0,"name":"Sale","display_name":"Sale","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":11,"model_type":"App\\Models\\User"}},{"id":12,"biz_business_id":0,"name":"SaleManager","display_name":"SaleManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":12,"model_type":"App\\Models\\User"}},{"id":14,"biz_business_id":0,"name":"UserManager","display_name":"UserManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":14,"model_type":"App\\Models\\User"}},{"id":17,"biz_business_id":0,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":17,"model_type":"App\\Models\\User"}},{"id":26,"biz_business_id":0,"name":"Tr\u1ee3 gi\u1ea3ng","display_name":"Tr\u1ee3 gi\u1ea3ng","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":26,"model_type":"App\\Models\\User"}},{"id":27,"biz_business_id":0,"name":"Customer service","display_name":"Customer service","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":27,"model_type":"App\\Models\\User"}}]}

CSKH Gitiho Việt Nam 29 Aug 2023

Dạ chỗ đó anh/chị không để xuống dòng thử xem sao ạ 
{"id":343891,"crm_contact_id":600266,"name":"L\u00ea Minh Thu\u1ef3 Ph\u01b0\u1ee3ng","email":"leephuong1402@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"2d735fdce1f4f7e7f12f3816e3a4b7f6","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-15T07:32:51.000000Z","updated_at":"2023-08-14T06:27:06.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":"0933906468","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":20437,"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":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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_344\/le-phuong.png","link_profile":"https:\/\/gitiho.com\/u\/343891-le-minh-thuy-phuong","business_employers":[],"vip_account":null,"roles":[]}

Lê Minh Thuỳ Phượng 30 Aug 2023

vẫn không được ạ

 
{"id":82548,"crm_contact_id":29934,"name":"CSKH Gitiho Vi\u1ec7t Nam","email":"hotro@gitiho.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-02-12 17:12:54","confirmation_code":"ccae872502b90d64fa68a5773858a513","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-01-30T15:32:47.000000Z","updated_at":"2023-09-18T12:57:58.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1652762083.png","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"CSKH Gitiho Vi\u1ec7t Nam","address":"Gitiho Vi\u1ec7t Nam","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0774116285","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":8000,"google_id":"109213028097135238411","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":32,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1652762083.png","link_profile":"https:\/\/gitiho.com\/u\/82548-cskh-gitiho-viet-nam","business_employers":[{"id":2713,"biz_business_id":79,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0},{"id":2715,"biz_business_id":12,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0},{"id":2716,"biz_business_id":61,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0}],"vip_account":null,"roles":[{"id":10,"biz_business_id":0,"name":"CourseManager","display_name":"CourseManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":10,"model_type":"App\\Models\\User"}},{"id":11,"biz_business_id":0,"name":"Sale","display_name":"Sale","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":11,"model_type":"App\\Models\\User"}},{"id":12,"biz_business_id":0,"name":"SaleManager","display_name":"SaleManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":12,"model_type":"App\\Models\\User"}},{"id":14,"biz_business_id":0,"name":"UserManager","display_name":"UserManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":14,"model_type":"App\\Models\\User"}},{"id":17,"biz_business_id":0,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":17,"model_type":"App\\Models\\User"}},{"id":26,"biz_business_id":0,"name":"Tr\u1ee3 gi\u1ea3ng","display_name":"Tr\u1ee3 gi\u1ea3ng","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":26,"model_type":"App\\Models\\User"}},{"id":27,"biz_business_id":0,"name":"Customer service","display_name":"Customer service","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":27,"model_type":"App\\Models\\User"}}]}

CSKH Gitiho Việt Nam 30 Aug 2023

Dạ hiện đang báo lỗi như thế nào ạ?
Phung Minh Tuan

Phung Minh Tuan 12 Aug 2023

Chào anh/chị,

Vui lòng xem giúp minh hình ảnh đính kèm, khi mình chạy macro Delete_All_Shapes() thi bị lỗi.

Vui lòng hướng dẫn cách khắc phục.

Xin cảm ơn.

 
CSKH Gitiho Việt Nam

CSKH Gitiho Việt Nam 15 Aug 2023

Chào anh/chị,

Câu lệnh Dim shp as Shape bị sai
Dim shp as Object nó là 1 object chứ ko khai báo cụ thể là shape ngay được
lúc vào vòng lặp for each thì object đó mới được hiểu là Shape
{"id":336253,"crm_contact_id":586609,"name":"Phung Minh Tuan","email":"tuan.phmt@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"311c1d9540c0b0891a17d2bac2bd98b7","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-06-18T11:22:40.000000Z","updated_at":"2023-08-09T07:55:00.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":"0988434887","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":25097,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_336\/phung-tuan.png","link_profile":"https:\/\/gitiho.com\/u\/336253-phung-minh-tuan","business_employers":[],"vip_account":null,"roles":[]}

Phung Minh Tuan 15 Aug 2023

Chào anh/chị,

 

Mình đã khai báo lại thành Object. Nhưng vẫn báo  lỗi.

Vui lòng xem lại giúp minh nhé?
{"id":336253,"crm_contact_id":586609,"name":"Phung Minh Tuan","email":"tuan.phmt@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"311c1d9540c0b0891a17d2bac2bd98b7","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-06-18T11:22:40.000000Z","updated_at":"2023-08-09T07:55:00.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":"0988434887","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":25097,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_336\/phung-tuan.png","link_profile":"https:\/\/gitiho.com\/u\/336253-phung-minh-tuan","business_employers":[],"vip_account":null,"roles":[]}

Phung Minh Tuan 15 Aug 2023

Minh gửi hinh minh hoa lỗi
{"id":82548,"crm_contact_id":29934,"name":"CSKH Gitiho Vi\u1ec7t Nam","email":"hotro@gitiho.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-02-12 17:12:54","confirmation_code":"ccae872502b90d64fa68a5773858a513","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-01-30T15:32:47.000000Z","updated_at":"2023-09-18T12:57:58.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1652762083.png","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"CSKH Gitiho Vi\u1ec7t Nam","address":"Gitiho Vi\u1ec7t Nam","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0774116285","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":8000,"google_id":"109213028097135238411","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":32,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1652762083.png","link_profile":"https:\/\/gitiho.com\/u\/82548-cskh-gitiho-viet-nam","business_employers":[{"id":2713,"biz_business_id":79,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0},{"id":2715,"biz_business_id":12,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0},{"id":2716,"biz_business_id":61,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0}],"vip_account":null,"roles":[{"id":10,"biz_business_id":0,"name":"CourseManager","display_name":"CourseManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":10,"model_type":"App\\Models\\User"}},{"id":11,"biz_business_id":0,"name":"Sale","display_name":"Sale","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":11,"model_type":"App\\Models\\User"}},{"id":12,"biz_business_id":0,"name":"SaleManager","display_name":"SaleManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":12,"model_type":"App\\Models\\User"}},{"id":14,"biz_business_id":0,"name":"UserManager","display_name":"UserManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":14,"model_type":"App\\Models\\User"}},{"id":17,"biz_business_id":0,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":17,"model_type":"App\\Models\\User"}},{"id":26,"biz_business_id":0,"name":"Tr\u1ee3 gi\u1ea3ng","display_name":"Tr\u1ee3 gi\u1ea3ng","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":26,"model_type":"App\\Models\\User"}},{"id":27,"biz_business_id":0,"name":"Customer service","display_name":"Customer service","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":27,"model_type":"App\\Models\\User"}}]}

CSKH Gitiho Việt Nam 15 Aug 2023

Chào anh/chị, 

Dòng này anh/chị thử sửa lại For Each shp In ActiveSheet.Shapes , thêm chữ S ở Shape xem sao 
{"id":336253,"crm_contact_id":586609,"name":"Phung Minh Tuan","email":"tuan.phmt@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"311c1d9540c0b0891a17d2bac2bd98b7","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-06-18T11:22:40.000000Z","updated_at":"2023-08-09T07:55:00.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":"0988434887","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":25097,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_336\/phung-tuan.png","link_profile":"https:\/\/gitiho.com\/u\/336253-phung-minh-tuan","business_employers":[],"vip_account":null,"roles":[]}

Phung Minh Tuan 15 Aug 2023

Chào anh/Chị, 

Cám ơn anh/chị. Đúng là thêm s và Shapes là OK rồi.

Cám ơn anh/chị.
{"id":82548,"crm_contact_id":29934,"name":"CSKH Gitiho Vi\u1ec7t Nam","email":"hotro@gitiho.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-02-12 17:12:54","confirmation_code":"ccae872502b90d64fa68a5773858a513","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-01-30T15:32:47.000000Z","updated_at":"2023-09-18T12:57:58.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1652762083.png","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"CSKH Gitiho Vi\u1ec7t Nam","address":"Gitiho Vi\u1ec7t Nam","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0774116285","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":8000,"google_id":"109213028097135238411","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":32,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1652762083.png","link_profile":"https:\/\/gitiho.com\/u\/82548-cskh-gitiho-viet-nam","business_employers":[{"id":2713,"biz_business_id":79,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0},{"id":2715,"biz_business_id":12,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0},{"id":2716,"biz_business_id":61,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0}],"vip_account":null,"roles":[{"id":10,"biz_business_id":0,"name":"CourseManager","display_name":"CourseManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":10,"model_type":"App\\Models\\User"}},{"id":11,"biz_business_id":0,"name":"Sale","display_name":"Sale","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":11,"model_type":"App\\Models\\User"}},{"id":12,"biz_business_id":0,"name":"SaleManager","display_name":"SaleManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":12,"model_type":"App\\Models\\User"}},{"id":14,"biz_business_id":0,"name":"UserManager","display_name":"UserManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":14,"model_type":"App\\Models\\User"}},{"id":17,"biz_business_id":0,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":17,"model_type":"App\\Models\\User"}},{"id":26,"biz_business_id":0,"name":"Tr\u1ee3 gi\u1ea3ng","display_name":"Tr\u1ee3 gi\u1ea3ng","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":26,"model_type":"App\\Models\\User"}},{"id":27,"biz_business_id":0,"name":"Customer service","display_name":"Customer service","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":27,"model_type":"App\\Models\\User"}}]}

CSKH Gitiho Việt Nam 15 Aug 2023

Dạ không có gì, chúc anh/chi học tập hiệu quả
Nguyen Thi Hoa

Nguyen Thi Hoa 01 Aug 2023

Xin GV hướng dẫn cách tạo file trừ tồn kho theo ngày giúp ạ. Số lượng tồn kho bị trừ phải đi kèm với đơn giá nhập khao
CSKH Gitiho Việt Nam

CSKH Gitiho Việt Nam 15 Aug 2023

Chào anh/chị,
Việc tính giá xuất kho vốn là 1 cái rất phức tạp trong kế toán, thường excel chỉ tính theo giá trung bình thôi, ở đây tính theo ngày thì có thể có nhiều cách tính khác, như nhập trước xuất trước thì ko tính được, chỉ tính số lượng được thôi, chứ ko tính kèm theo giá tiền, nội dung này thì anh/chị xem cách dùng hàm sumifs trong tính nhập-xuất-tồn nhé ạ
Lê Minh Thuỳ Phượng

Lê Minh Thuỳ Phượng 08 Aug 2023


 
Phung Minh Tuan

Phung Minh Tuan 12 Aug 2023

Minh cũng bị lỗi tương tự. Phiền thầy/cô hướng dẫn lỗi này? Mình cám ơn.
{"id":343891,"crm_contact_id":600266,"name":"L\u00ea Minh Thu\u1ef3 Ph\u01b0\u1ee3ng","email":"leephuong1402@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"2d735fdce1f4f7e7f12f3816e3a4b7f6","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-15T07:32:51.000000Z","updated_at":"2023-08-14T06:27:06.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":"0933906468","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":20437,"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":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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_344\/le-phuong.png","link_profile":"https:\/\/gitiho.com\/u\/343891-le-minh-thuy-phuong","business_employers":[],"vip_account":null,"roles":[]}

Lê Minh Thuỳ Phượng 14 Aug 2023

Thầy/cô hướng dẫn giúp em ạ. Em cám ơn

 
Nguyen Thi Hoa

Nguyen Thi Hoa 01 Aug 2023

XIN HƯỚNG DẪN CODE ĐỂ TÁCH CÁC MÃ HÀNG THÀNH TỪ SHEET Ạ
Nguyen Thi Hoa

Nguyen Thi Hoa 01 Aug 2023

{"id":345072,"crm_contact_id":602649,"name":"Nguyen Thi Hoa","email":"hoanguyenbaolam@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2023-07-28 09:00:12","confirmation_code":"79f5ff29ad6dad360b30386038bbd1ac","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-20T12:03:29.000000Z","updated_at":"2023-08-13T03:05:53.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":21404,"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":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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_345\/nguyen-hoa.png","link_profile":"https:\/\/gitiho.com\/u\/345072-nguyen-thi-hoa","business_employers":[],"vip_account":null,"roles":[]}

Nguyen Thi Hoa 01 Aug 2023

CHO E XIN MÃ CODE NÀY VỚI Ạ. THANKS
69,000đ
Scroll Top Top

Hỗ trợ khách hàng

VỀ GITIHO

hợp tác và liên kết

Tải App Gitiho

Kết nối với chúng tôi

Địa chỉ văn phòng: Phòng 302, tầng 3, Tòa nhà Tây Hà, KĐT mới Phùng Khoang, Phường Trung Văn, Quận Nam Từ Liêm, Thành phố Hà Nội, Việt Nam
@ 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
Giấy phép mạng xã hội số: 588, cấp bởi Bộ thông tin và truyền thông
/