{"id":5321,"date":"2024-12-10T22:09:20","date_gmt":"2024-12-10T22:09:20","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/cach-tao-combobox-co-danh-sach-phu-thuoc-nhau\/"},"modified":"2024-12-10T22:09:20","modified_gmt":"2024-12-10T22:09:20","slug":"cach-tao-combobox-co-danh-sach-phu-thuoc-nhau","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/10\/cach-tao-combobox-co-danh-sach-phu-thuoc-nhau\/","title":{"rendered":"C\u00e1ch t\u1ea1o Combobox c\u00f3 danh s\u00e1ch ph\u1ee5 thu\u1ed9c nhau"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p><em>Trong b\u00e0i tr\u01b0\u1edbc ch\u00fang ta\u00a0\u0111\u00e3 t\u00ecm hi\u1ec3u v\u1ec1 <strong>c\u00e1ch s\u1eed d\u1ee5ng ComboBox v\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/tao-danh-sach-khong-co-gia-tri-trung-trong-combobox.html\">t\u1ea1o danh s\u00e1ch kh\u00f4ng b\u1ecb tr\u00f9ng trong Combobox<\/a>.<\/strong> V\u00e0\u00a0\u0111\u1ec3 n\u00e2ng cao h\u01a1n ki\u1ebfn th\u1ee9c v\u1ec1 Combobox, ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch <strong>t\u1ea1o ra nh\u1eefng Combobox c\u00f3 danh s\u00e1ch ph\u1ee5 thu\u1ed9c nhau<\/strong>.\u00a0\u0110i\u1ec1u n\u00e0y ngh\u0129a l\u00e0: M\u1ed7i gi\u00e1 tr\u1ecb\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn\u00a0\u1edf Combobox n\u00e0y s\u1ebd l\u00e0m thay\u00a0\u0111\u1ed5i danh s\u00e1ch n\u1ea1p v\u00e0o\u00a0\u1edf Combobox kh\u00e1c.<\/em><\/p>\n<p>Nh\u1eefng n\u1ed9i dung ch\u00fang ta c\u1ea7n t\u00ecm hi\u1ec3u trong b\u00e0i h\u1ecdc n\u00e0y bao g\u1ed3m:<\/p>\n<ul>\n<li>Ph\u00e2n c\u1ea5p b\u1eadc c\u00e1c\u00a0danh s\u00e1ch theo combobox<\/li>\n<li>T\u1ea1o combobox t\u01b0\u01a1ng\u00a0\u1ee9ng theo c\u00e1c danh s\u00e1ch<\/li>\n<li>T\u1ea1o\u00a0danh s\u00e1ch kh\u00f4ng tr\u00f9ng\u00a0 b\u1eb1ng vba trong t\u1eebng combobox<\/li>\n<li>T\u1ea1o\u00a0\u0111i\u1ec1u ki\u1ec7n ph\u1ee5 thu\u1ed9c nhau cho c\u00e1c danh s\u00e1ch trong combobox<\/li>\n<\/ul>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6758bc0fd0e9c\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-combobox-co-danh-sach-phu-thuoc-nhau.html#1_Phan_cap_bac_cac_danh_sach_theo_combobox\" title=\"1.\u00a0Ph\u00e2n c\u1ea5p\u00a0b\u1eadc c\u00e1c\u00a0danh s\u00e1ch theo combobox\">1.\u00a0Ph\u00e2n c\u1ea5p\u00a0b\u1eadc c\u00e1c\u00a0danh s\u00e1ch theo combobox<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-combobox-co-danh-sach-phu-thuoc-nhau.html#2_Tao_combobox_tuong_ung_theo_cac_danh_sach\" title=\"2.\u00a0T\u1ea1o combobox t\u01b0\u01a1ng\u00a0\u1ee9ng theo c\u00e1c danh s\u00e1ch\">2.\u00a0T\u1ea1o combobox t\u01b0\u01a1ng\u00a0\u1ee9ng theo c\u00e1c danh s\u00e1ch<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-combobox-co-danh-sach-phu-thuoc-nhau.html#3_Tao_danh_sach_khong_trung_trong_Combobox\" title=\"3. T\u1ea1o danh s\u00e1ch kh\u00f4ng tr\u00f9ng trong Combobox\">3. T\u1ea1o danh s\u00e1ch kh\u00f4ng tr\u00f9ng trong Combobox<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-combobox-co-danh-sach-phu-thuoc-nhau.html#4_Tao_dieu_kien_phu_thuoc_nhau_giua_cac_danh_sach\" title=\"4. T\u1ea1o\u00a0\u0111i\u1ec1u ki\u1ec7n ph\u1ee5 thu\u1ed9c nhau gi\u1eefa c\u00e1c danh s\u00e1ch\">4. T\u1ea1o\u00a0\u0111i\u1ec1u ki\u1ec7n ph\u1ee5 thu\u1ed9c nhau gi\u1eefa c\u00e1c danh s\u00e1ch<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"1_Phan_cap_bac_cac_danh_sach_theo_combobox\"><\/span>1.\u00a0Ph\u00e2n c\u1ea5p\u00a0b\u1eadc c\u00e1c\u00a0danh s\u00e1ch theo combobox<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 h\u00ecnh dung v\u1ec1 c\u1ea5p b\u1eadc c\u00e1c danh s\u00e1ch, ch\u00fang ta x\u00e9t v\u00ed d\u1ee5 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14551\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-combobox-khong-trung-01.png\" width=\"437\" height=\"366\" title=\"heo-combobox-khong-trung-01\"><\/p>\n<p>Trong h\u00ecnh tr\u00ean ch\u00fang ta th\u1ea5y: M\u1ed7i nh\u00e2n vi\u00ean t\u1ea1i c\u1ed9t C s\u1ebd n\u1eb1m trong 1 nh\u00f3m c\u1ee5 th\u1ec3 trong c\u1ed9t B, v\u00e0 m\u1ed7i nh\u00f3m l\u1ea1i thu\u1ed9c m\u1ed9t b\u1ed9 ph\u1eadn nh\u1ea5t\u00a0\u0111\u1ecbnh trong c\u1ed9t A.<\/p>\n<p>Nh\u01b0 v\u1eady c\u00f3 s\u1ef1 ph\u00e2n c\u1ea5p b\u1eadc c\u00e1c danh s\u00e1ch nh\u01b0 sau:<\/p>\n<blockquote>\n<p>B\u1ed9 ph\u1eadn &gt; Nh\u00f3m &gt; Nh\u00e2n vi\u00ean<\/p>\n<\/blockquote>\n<ul>\n<li><strong>B\u1ed9 ph\u1eadn<\/strong> l\u00e0 danh s\u00e1ch c\u00f3 c\u1ea5p b\u1eadc l\u1edbn nh\u1ea5t, g\u1ecdi l\u00e0 b\u1eadc 1<\/li>\n<li><strong>Nh\u00f3m<\/strong> l\u00e0 danh s\u00e1ch c\u00f3 c\u1ea5p b\u1eadc nh\u1ecf h\u01a1n b\u1ed9 ph\u1eadn, ph\u1ee5 thu\u1ed9c v\u00e0o n\u1ed9i dung c\u1ee7a <strong>B\u1ed9 ph\u1eadn<\/strong>, g\u1ecdi l\u00e0 b\u1eadc 2<\/li>\n<li><strong>Nh\u00e2n vi\u00ean<\/strong> l\u00e0 danh s\u00e1ch c\u00f3 c\u1ea5p b\u1eadc nh\u1ecf nh\u1ea5t, ph\u1ee5 thu\u1ed9c v\u00e0o n\u1ed9i dung c\u1ee7a <strong>Nh\u00f3m<\/strong>, g\u1ecdi l\u00e0 b\u1eadc 3<\/li>\n<\/ul>\n<p>V\u1eady m\u1ee5c ti\u00eau ch\u00fang ta c\u1ea7n\u00a0\u0111\u1ea1t\u00a0\u0111\u01b0\u1ee3c l\u00e0:<\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-183.gif\" title=\"vba101_92019-nho-183\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-457.gif\" title=\"ex101_92019-nho-457\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>V\u1edbi m\u1ed7i b\u1ed9 ph\u1eadn\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn trong Combobox1 th\u00ec danh s\u00e1ch nh\u00f3m trong Combobox2 c\u1ea7n ph\u1ea3i thay\u00a0\u0111\u1ed5i t\u01b0\u01a1ng\u00a0\u1ee9ng theo b\u1ed9 ph\u1eadn\u00a0\u0111\u00f3.<\/li>\n<li>V\u1edbi m\u1ed7i\u00a0nh\u00f3m\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn trong Combobox2 th\u00ec danh s\u00e1ch\u00a0nh\u00e2n vi\u00ean\u00a0trong\u00a0Combobox3 c\u1ea7n ph\u1ea3i thay\u00a0\u0111\u1ed5i t\u01b0\u01a1ng\u00a0\u1ee9ng theo\u00a0nh\u00f3m \u0111\u00f3.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"2_Tao_combobox_tuong_ung_theo_cac_danh_sach\"><\/span>2.\u00a0T\u1ea1o combobox t\u01b0\u01a1ng\u00a0\u1ee9ng theo c\u00e1c danh s\u00e1ch<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u1ede\u00a0\u0111\u00e2y ch\u00fang ta c\u00f3 3 danh s\u00e1ch n\u00ean s\u1ebd c\u1ea7n t\u1ea1o 3 combobox c\u00f3 t\u00ean l\u1ea7n l\u01b0\u1ee3t l\u00e0 Combobox1,\u00a0Combobox2,\u00a0Combobox3<\/p>\n<p>Ch\u00fang ta s\u1ebd s\u1eafp x\u1ebfp th\u1ee9 t\u1ef1 c\u00e1c combobox l\u1ea7n l\u01b0\u1ee3t nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14588\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-combobox-phu-thuoc-01.png\" width=\"1007\" height=\"364\" title=\"heo-combobox-phu-thuoc-01\"><\/p>\n<p>Combobox1 s\u1ebd l\u1ea5y danh s\u00e1ch B\u1ed9 ph\u1eadn<\/p>\n<p>Combobox2 s\u1ebd l\u1ea5y danh s\u00e1ch Nh\u00f3m<\/p>\n<p>Combobox3 s\u1ebd l\u1ea5y danh s\u00e1ch Nh\u00e2n vi\u00ean<\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_Tao_danh_sach_khong_trung_trong_Combobox\"><\/span>3. T\u1ea1o danh s\u00e1ch kh\u00f4ng tr\u00f9ng trong Combobox<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u1ede c\u00e1c danh s\u00e1ch B\u1ed9 ph\u1eadn v\u00e0 Nh\u00f3m ch\u00fang ta th\u1ea5y c\u00f3 xu\u1ea5t hi\u1ec7n c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng nhau. Do\u00a0\u0111\u00f3\u00a0\u0111\u1ec3 cho danh s\u00e1ch ch\u1ecdn c\u1ee7a combobox kh\u00f4ng xu\u1ea5t hi\u1ec7n c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng n\u00e0y th\u00ec ch\u00fang ta c\u00f3 th\u1ec3\u00a0\u00e1p d\u1ee5ng c\u00e1ch l\u00e0m t\u01b0\u01a1ng t\u1ef1\u00a0\u1edf b\u00e0i tr\u01b0\u1edbc\u00a0\u0111\u1ec3 th\u1ef1c hi\u1ec7n.<\/p>\n<p>T\u1ea1o danh s\u00e1ch kh\u00f4ng tr\u00f9ng trong Combobox1:<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/DuongAQ\/c6352f8ef46501c70979a83e6e7808bb\">Gist<\/a>.<\/div>\n<p>T\u1eeb c\u00e1c combobox2 v\u00e0 combobox3 ch\u00fang ta th\u1ea5y n\u00f3 ph\u1ee5 thu\u1ed9c v\u00e0o n\u1ed9i dung c\u1ee7a combobox b\u1eadc tr\u01b0\u1edbc n\u00f3, do\u00a0\u0111\u00f3 ch\u00fang ta s\u1ebd k\u1ebft h\u1ee3p vi\u1ec7c t\u1ea1o\u00a0\u0111i\u1ec1u ki\u1ec7n ph\u1ee5 thu\u1ed9c v\u1edbi vi\u1ec7c l\u1ecdc c\u00e1c gi\u00e1 tr\u1ecb tr\u00f9ng.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"4_Tao_dieu_kien_phu_thuoc_nhau_giua_cac_danh_sach\"><\/span>4. T\u1ea1o\u00a0\u0111i\u1ec1u ki\u1ec7n ph\u1ee5 thu\u1ed9c nhau gi\u1eefa c\u00e1c danh s\u00e1ch<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0\u00a0\u0111\u00e3 l\u1eadp lu\u1eadn\u00a0\u1edf tr\u00ean: \u201c<em>V\u1edbi m\u1ed7i b\u1ed9 ph\u1eadn\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn trong Combobox1 th\u00ec danh s\u00e1ch nh\u00f3m trong Combobox2 c\u1ea7n ph\u1ea3i thay\u00a0\u0111\u1ed5i t\u01b0\u01a1ng\u00a0\u1ee9ng theo b\u1ed9 ph\u1eadn\u00a0\u0111\u00f3<\/em>\u201d =&gt; Nh\u01b0 v\u1eady vi\u1ec7c thay\u00a0\u0111\u1ed5i danh s\u00e1ch ch\u1ecdn trong combobox2 ph\u1ee5 thu\u1ed9c v\u00e0o vi\u1ec7c n\u1ed9i dung trong combobox1 c\u00f3 thay\u00a0\u0111\u1ed5i hay kh\u00f4ng.\u00a0\u0110i\u1ec1u n\u00e0y trong VBA\u00a0\u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 s\u1ef1 ki\u1ec7n <strong>Combobox1_Change<\/strong><\/p>\n<p>T\u1ea1i Sheet ch\u1ee9a c\u00e1c combobox\u00a0c\u1ea7n th\u1ef1c hi\u1ec7n (\u1edf\u00a0\u0111\u00e2y l\u00e0 <strong>Sheet3<\/strong>) ch\u1ecdn\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng <strong>Combobox<\/strong> thay cho\u00a0<strong>Worksheet<\/strong>, ti\u1ebfp\u00a0\u0111\u00f3 ch\u1ecdn s\u1ef1 ki\u1ec7n <strong>Change<\/strong> cho combobox\u00a0\u0111\u00f3 (s\u1ef1 ki\u1ec7n Change s\u1ebd l\u00e0 m\u1eb7c\u00a0\u0111\u1ecbnh khi ch\u1ecdn\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng\u00a0Combobox)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14589\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-combobox-phu-thuoc-02.png\" width=\"1312\" height=\"340\" title=\"heo-combobox-phu-thuoc-02\"><\/p>\n<p>C\u00e2u l\u1ec7nh VBA\u00a0\u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/DuongAQ\/c49e0d758f180f2d99c9254e938a8b38\">Gist<\/a>.<\/div>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 th\u1ec3 t\u1ea1o\u00a0\u0111\u01b0\u1ee3c danh s\u00e1ch t\u1ea1i ComboBox2 ph\u1ee5 thu\u1ed9c v\u00e0o m\u1ed7i gi\u00e1 tr\u1ecb\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn t\u1ea1i Combobox1 r\u1ed3i.<\/p>\n<p>Ti\u1ebfp theo l\u00e0\u00a0\u0111\u1ec3 ComboBox3 ph\u1ee5 thu\u1ed9c v\u00e0o ComboBox2 th\u00ec ch\u00fang ta l\u00e0m nh\u01b0 sau:<\/p>\n<ul>\n<li>T\u1ea1o s\u1ef1\u00a0ki\u1ec7n thay\u00a0\u0111\u1ed5i\u00a0\u1edf combobox2: Private Sub ComboBox2_Change<\/li>\n<li>Copy n\u1ed9i dung c\u1ee7a Private Sub ComboBox1_Change v\u00e0 paste v\u00e0o\u00a0\u0111\u00e2y<\/li>\n<li>S\u1eeda c\u00e1c n\u1ed9i dung: Bi\u1ebfn <strong>rng<\/strong> thay v\u00ec\u00a0\u00e1p d\u1ee5ng Range cho c\u1ed9t A th\u00ec s\u1eeda th\u00e0nh c\u1ed9t B<\/li>\n<li>T\u1ea1i <strong>v\u00f2ng l\u1eb7p v\u1edbi bi\u1ebfn r<\/strong> th\u00ec x\u00e9t r = ComboBox2<\/li>\n<li>Cu\u1ed1i c\u00f9ng khi <strong>l\u1ea5y d\u1eef li\u1ec7u v\u00e0o Combobox<\/strong> th\u00ec\u00a0\u0111\u1ed5i th\u00e0nh ComboBox3<\/li>\n<\/ul>\n<p>C\u00e2u l\u1ec7nh VBA nh\u01b0 sau (<em><strong>nh\u1eefng n\u1ed9i dung thay\u00a0\u0111\u1ed5i c\u1ea7n ch\u00fa\u00a0\u00fd\u00a0\u0111\u01b0\u1ee3c\u00a0\u0111\u1eb7t trong ph\u1ea7n d\u1ea5u ***<\/strong><\/em>)<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/DuongAQ\/7551cc64323514633e0ceff3f5bf1dc0\">Gist<\/a>.<\/div>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta\u00a0\u0111\u00e3 ho\u00e0n th\u00e0nh\u00a0\u0111\u01b0\u1ee3c y\u00eau c\u1ea7u ban\u00a0\u0111\u1ea7u r\u1ed3i.<\/p>\n<p>M\u1ed9t l\u01b0u\u00a0\u00fd l\u00e0 trong ComboBox\u00a0\u0111\u00f4i khi b\u1ecb l\u1ed7i font ch\u1eef khi ch\u00fang ta ch\u1ecdn 1 gi\u00e1 tr\u1ecb ti\u1ebfng vi\u1ec7t c\u00f3 d\u1ea5u.\u00a0\u0110\u1ec3 kh\u1eafc ph\u1ee5c\u00a0\u0111i\u1ec1u n\u00e0y th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 c\u00f3 1 s\u1ed1\u00a0c\u00e1ch sau:<\/p>\n<ul>\n<li>S\u1eed d\u1ee5ng ti\u1ebfng vi\u1ec7t kh\u00f4ng d\u1ea5u<\/li>\n<li>T\u1ea1o li\u00ean k\u1ebft t\u1eeb combobox ra 1 v\u1ecb tr\u00ed t\u1ea1i\u00a0worksheet\u00a0\u0111\u1ec3 c\u00f3 k\u1ebft qu\u1ea3\u00a0\u0111\u00fang (d\u00f9 l\u1ed7i font hi\u1ec3n th\u1ecb nh\u01b0ng k\u1ebft qu\u1ea3 li\u00ean k\u1ebft v\u1eabn\u00a0\u0111\u00fang)<\/li>\n<li>S\u1eed d\u1ee5ng b\u1ed9 g\u00f5 kh\u00e1c (h\u1ebft s\u1ee9c l\u01b0u\u00a0\u00fd v\u00ec c\u00f3 th\u1ec3 l\u1ed7i font khi g\u1eedi sang m\u00e1y t\u00ednh kh\u00e1c)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-14591\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/heo-combobox-phu-thuoc-03.png\" width=\"1011\" height=\"365\" title=\"heo-combobox-phu-thuoc-03\"><\/p>\n<p>C\u1ea3m \u01a1n c\u00e1c b\u1ea1n \u0111\u00e3 theo d\u00f5i b\u00e0i vi\u1ebft, mong r\u1eb1ng b\u1ea1n \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1ch t\u1ea1o Combobox ph\u1ee5 thu\u1ed9c r\u1ed3i. Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng <strong>H\u1ecdc\u00a0Excel Online<\/strong>!<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-183.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5322,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5321","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5321","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=5321"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5321\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5322"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5321"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5321"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}