{"id":3603,"date":"2024-12-03T03:04:45","date_gmt":"2024-12-03T03:04:45","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/ung-dung-chon-ngay-dung-trong-excel-va-vba-calendar-form\/"},"modified":"2024-12-03T03:04:45","modified_gmt":"2024-12-03T03:04:45","slug":"ung-dung-chon-ngay-dung-trong-excel-va-vba-calendar-form","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/ung-dung-chon-ngay-dung-trong-excel-va-vba-calendar-form\/","title":{"rendered":"\u1ee8ng d\u1ee5ng Ch\u1ecdn ng\u00e0y d\u00f9ng trong Excel v\u00e0 VBA (Calendar Form)"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p><em>B\u00e0i vi\u1ebft s\u1ebd \u0111\u1ec1 c\u1eadp \u0111\u1ebfn c\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a \u1ee9ng d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ung-dung-chon-ngay-dung-trong-excel-va-vba-calendar-form.html\"><strong>Date Picker Calendar Form<\/strong><\/a> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong <a href=\"http:\/\/blog.ezworkapp.com\/excel-vba\"><strong>VBA Excel <\/strong><\/a>(k\u00e8m v\u1edbi link t\u1ea3i) \u00a0c\u0169ng nh\u01b0 nh\u1eefng \u0111i\u1ec3m kh\u00e1c bi\u1ec7t c\u1ee7a n\u00f3 so v\u1edbi <strong>Date Picker Add-in<\/strong> d\u00f9ng trong m\u00f4i tr\u01b0\u1eddng Excel . C\u00f9ng b\u1eaft \u0111\u1ea7u ngay th\u00f4i n\u00e0o!<\/em><\/p>\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-674e754c3a858\" 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\/ung-dung-chon-ngay-dung-trong-excel-va-vba-calendar-form.html#Gioi_thieu_Cong_cu_ho_tro_chon_ngay_trong_Excel\" title=\"Gi\u1edbi thi\u1ec7u C\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 ch\u1ecdn ng\u00e0y trong Excel\">Gi\u1edbi thi\u1ec7u C\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 ch\u1ecdn ng\u00e0y trong Excel<\/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\/ung-dung-chon-ngay-dung-trong-excel-va-vba-calendar-form.html#Tai_ve_Calendar_Form\" title=\"T\u1ea3i v\u1ec1 Calendar Form\">T\u1ea3i v\u1ec1 Calendar Form<\/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\/ung-dung-chon-ngay-dung-trong-excel-va-vba-calendar-form.html#Huong_dan_cai_dat_va_su_dung_Calendar_Form\" title=\"H\u01b0\u1edbng d\u1eabn c\u00e0i \u0111\u1eb7t v\u00e0 s\u1eed d\u1ee5ng Calendar Form\">H\u01b0\u1edbng d\u1eabn c\u00e0i \u0111\u1eb7t v\u00e0 s\u1eed d\u1ee5ng Calendar Form<\/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\/ung-dung-chon-ngay-dung-trong-excel-va-vba-calendar-form.html#Cac_vi_du_ung_dung_cua_Calendar_Form\" title=\"C\u00e1c v\u00ed d\u1ee5 \u1ee9ng d\u1ee5ng c\u1ee7a Calendar Form\">C\u00e1c v\u00ed d\u1ee5 \u1ee9ng d\u1ee5ng c\u1ee7a Calendar Form<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/ung-dung-chon-ngay-dung-trong-excel-va-vba-calendar-form.html#Ung_dung_Macro_de_hien_thi_DatePicker_trong_o_cua_Excel\" title=\"\u1ee8ng d\u1ee5ng Macro \u0111\u1ec3 hi\u1ec3n th\u1ecb DatePicker trong \u00f4 c\u1ee7a Excel\">\u1ee8ng d\u1ee5ng Macro \u0111\u1ec3 hi\u1ec3n th\u1ecb DatePicker trong \u00f4 c\u1ee7a Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/ung-dung-chon-ngay-dung-trong-excel-va-vba-calendar-form.html#Ung_dung_gan_vao_Textbox_trong_Userform_VBA\" title=\"\u1ee8ng d\u1ee5ng g\u00e1n v\u00e0o Textbox trong Userform VBA\">\u1ee8ng d\u1ee5ng g\u00e1n v\u00e0o Textbox trong Userform VBA<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Gioi_thieu_Cong_cu_ho_tro_chon_ngay_trong_Excel\"><\/span>Gi\u1edbi thi\u1ec7u C\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 ch\u1ecdn ng\u00e0y trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tr\u01b0\u1edbc \u0111\u00e2y, m\u00ecnh t\u1eebng c\u00f3 m\u1ed9t b\u00e0i vi\u1ebft gi\u1edbi thi\u1ec7u v\u1ec1 <strong>Date Picker Add-in<\/strong> d\u00f9ng trong m\u00f4i tr\u01b0\u1eddng Excel. Tuy nhi\u00ean, do t\u00ednh \u0111\u00f3ng g\u00f3i v\u00e0 b\u1ea3o m\u1eadt c\u1ee7a t\u00e1c gi\u1ea3 n\u00ean ch\u00fang ta kh\u00f3 v\u1eadn d\u1ee5ng n\u00f3 trong m\u00f4i tr\u01b0\u1eddng VBA, vi\u1ec7c t\u00e1i s\u1eed d\u1ee5ng trong c\u00e1c Userform g\u1eb7p kh\u00f3 kh\u0103n nh\u1ea5t \u0111\u1ecbnh.<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/excel-datepicker.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31755 size-medium\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-datepicker-300x187-1.png\" width=\"300\" height=\"187\" title=\"excel-datepicker-300x187-1\"><\/a><\/p>\n<p>V\u1eady b\u00e2y gi\u1edd Date Picker Calendar Form kh\u00e1c g\u00ec so v\u1edbi add-in? N\u1ebfu b\u1ea1n t\u00ecm hi\u1ec3u VBA s\u1ebd l\u00e0m quen v\u1edbi c\u00e1c kh\u00e1c ni\u1ec7m: Class, Userform, Module\u2026<\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 xem l\u1ea1i b\u00e0i vi\u1ebft qua \u0111\u01b0\u1eddng d\u1eabn sau:<\/p>\n<ul>\n<li><strong><a href=\"http:\/\/blog.ezworkapp.com\/add-in-chon-ngay-trong-excel-excel-date-picker.html\" target=\"_blank\" rel=\"noopener noreferrer\">Add-in ch\u1ecdn ng\u00e0y trong Excel (Excel Date Picker)<\/a><\/strong><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Tai_ve_Calendar_Form\"><\/span>T\u1ea3i v\u1ec1 Calendar Form<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u1ea1n c\u00f3 th\u1ec3 truy c\u1eadp t\u1ea1i website ch\u00ednh ch\u1ee7: <strong><a href=\"https:\/\/trevoreyre.com\/portfolio\/excel-datepicker\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/trevoreyre.com\/portfolio\/excel-datepicker\/<\/a><\/strong><\/p>\n<p>Link t\u1ea3i d\u1ef1 ph\u00f2ng: <strong><a href=\"https:\/\/bit.ly\/calendarfrm\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/bit.ly\/calendarfrm<\/a><\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Huong_dan_cai_dat_va_su_dung_Calendar_Form\"><\/span>H\u01b0\u1edbng d\u1eabn c\u00e0i \u0111\u1eb7t v\u00e0 s\u1eed d\u1ee5ng Calendar Form<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/import-user-form.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31754 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/import-user-form.jpg\" alt=\"calender-form-1\" width=\"867\" height=\"586\" title=\"import-user-form\"><\/a><\/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-119.gif\" title=\"vba101_92019-nho-119\"><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-278.gif\" title=\"ex101_92019-nho-278\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ol>\n<li>Sau khi t\u1ea3i v\u1ec1, b\u1ea1n c\u1ea7n gi\u1ea3i n\u00e9n ra th\u01b0 m\u1ee5c. (B\u00ean trong s\u1ebd c\u00f3 file CalendarForm v1.5.2.xlsm h\u01b0\u1edbng d\u1eabn v\u00e0 v\u00ed d\u1ee5 cho b\u1ea1n c\u00e1c th\u00f4ng s\u1ed1 t\u01b0\u01a1ng \u1ee9ng).<\/li>\n<li>\u1ede file b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng, b\u1ea1n nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm ALT + F11 \u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 l\u1eadp tr\u00ecnh VBA.<\/li>\n<li>\u1ede c\u1eeda s\u1ed5 Project Explorer (b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn menu View r\u1ed3i ch\u1ecdn Project Explorer, ph\u00edm t\u1eaft: CTRL+R)<\/li>\n<li>B\u1ea1n click ph\u1ea3i Project b\u1ea1n c\u1ea7n import, sau \u0111\u00f3 ch\u1ecdn Import File\u2026<\/li>\n<li>Ch\u1ecdn file CalendarForm.frm m\u00e0 b\u1ea1n \u0111\u00e3 gi\u1ea3i n\u00e9n \u1edf b\u01b0\u1edbc 1. V\u1eady l\u00e0 xong.<\/li>\n<li>Sau khi \u0111\u00e3 ho\u00e0n t\u1ea5t b\u01b0\u1edbc tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng b\u1eb1ng c\u00e1ch khai b\u00e1o bi\u1ebfn, ra g\u1ecdi n\u00f3 ra.<\/li>\n<\/ol>\n<pre style=\"padding-left: 40px\">Dim dateVariable as Date\r\ndateVariable = CalendarForm.GetDate<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Cac_vi_du_ung_dung_cua_Calendar_Form\"><\/span>C\u00e1c v\u00ed d\u1ee5 \u1ee9ng d\u1ee5ng c\u1ee7a Calendar Form<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Ung_dung_Macro_de_hien_thi_DatePicker_trong_o_cua_Excel\"><\/span>\u1ee8ng d\u1ee5ng Macro \u0111\u1ec3 hi\u1ec3n th\u1ecb DatePicker trong \u00f4 c\u1ee7a Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 \u0111o\u1ea1n code v\u00ed d\u1ee5 m\u00e0 t\u00e1c gi\u1ea3 \u0111\u00e3 v\u1eadn d\u1ee5ng, ta th\u1ea5y \u00f4 \u0111\u01b0\u1ee3c g\u00e1n l\u00e0 H16. Khi b\u1ea1n c\u1ea7n d\u00f9ng, ch\u1ec9 vi\u1ec7c g\u1ecdi macro BasicCalendar l\u00ean l\u00e0 \u0111\u01b0\u1ee3c. L\u01b0u \u00fd khi l\u00e0m vi\u1ec7c v\u1edbi nhi\u1ec1u Sheet kh\u00e1c nhau, b\u1ea1n n\u00ean ch\u1ec9 r\u00f5 \u00f4 H16 thu\u1ed9c Sheet n\u00e0o nh\u00e9! V\u00ed d\u1ee5: <code>Sheets(\"Sheet1\").Range(\"H16\") = dateVariable<\/code>, khi \u00f4 b\u1ea1n \u00e1p d\u1ee5ng n\u1eb1m \u1edf Sheet c\u00f3 t\u00ean l\u00e0 Sheet1<\/p>\n<pre style=\"padding-left: 40px\">Sub BasicCalendar()\r\ndateVariable = CalendarForm.GetDate\r\nIf dateVariable &lt;&gt; 0 Then Range(\"H16\") = dateVariable\r\nEnd Sub<\/pre>\n<h3><span class=\"ez-toc-section\" id=\"Ung_dung_gan_vao_Textbox_trong_Userform_VBA\"><\/span>\u1ee8ng d\u1ee5ng g\u00e1n v\u00e0o Textbox trong Userform VBA<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t macro m\u00ecnh vi\u1ebft l\u1ea1i \u0111\u1ec3 v\u1eadn d\u1ee5ng cho c\u00e1c textbox. T\u01b0\u01a1ng \u1ee9ng v\u00ed d\u1ee5 khi ch\u1ecdn Check-in, Check-out, ta s\u1ebd g\u1ecdi l\u1ea1i macro b\u00ean d\u01b0\u1edbi m\u00e0 kh\u00f4ng ph\u1ea3i khai b\u00e1o l\u1eb7p \u0111i l\u1eb7p l\u1ea1i.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2020\/03\/calendar-form-textbox.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-31753 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/calendar-form-textbox.jpg\" alt=\"calender-form-2\" width=\"491\" height=\"309\" title=\"calendar-form-textbox\"><\/a><\/p>\n<p style=\"padding-left: 40px\"><code>Private Sub checkin_Enter()<\/code><br \/>\n<code>calDatepicker checkin<\/code><br \/>\n<code>End Sub<\/code><\/p>\n<p style=\"padding-left: 40px\"><code>Private Sub checkin_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)<\/code><br \/>\n<code>calDatepicker checkin<\/code><br \/>\n<code>KeyAscii = 0<\/code><br \/>\n<code>End Sub<\/code><\/p>\n<p style=\"padding-left: 40px\"><code>Private Sub calDatepicker(ctlTextbox As Control)<\/code><br \/>\n<code>Dim dteNgay As Date<\/code><\/p>\n<p style=\"padding-left: 40px\"><code>dteNgay = IIF(ctlTextbox.value, ctlTextbox.value,Now())<\/code><br \/>\n<code>dateVariable = CalendarForm.GetDate(SelectedDate:=dteNgay)<\/code><br \/>\n<code>If dateVariable &lt;&gt; 0 Then ctlTextbox = dateVariable<\/code><br \/>\n<code>End Sub<\/code><\/p>\n<p>Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng. \u0110\u1eebng qu\u00ean theo d\u00f5i<a href=\"http:\/\/blog.ezworkapp.com\"> <strong>H\u1ecdc Excel Online<\/strong><\/a> cho nh\u1eefng b\u00e0i h\u1ecdc b\u1ed5 \u00edch ti\u1ebfp theo nh\u00e9!<\/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-119.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3604,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3603","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\/3603","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=3603"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3603\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3604"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3603"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3603"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}