GENK IT

LOGO GROBOGAN

LOGO GROBOGAN

Amankan Konten Wordpressmu ..!!!

<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 21.0pt; text-align: justify;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOGN86Xq9wTET9HHI3p_kokIw3NT9WyGJvjkTy20io043HDDBJRvYvTEXY98cOplxnI6veIGJlaZedcZWAmvMey4BruNrUOdL2t6xCCt8PfKXltdQ4LnEwvT1xXwknXiJEzADH6nl1L0kR/s1600/EXPORT+IMPORT.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="295" data-original-width="640" height="183" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOGN86Xq9wTET9HHI3p_kokIw3NT9WyGJvjkTy20io043HDDBJRvYvTEXY98cOplxnI6veIGJlaZedcZWAmvMey4BruNrUOdL2t6xCCt8PfKXltdQ4LnEwvT1xXwknXiJEzADH6nl1L0kR/s400/EXPORT+IMPORT.JPG" width="400" /></a></div>
<span style="color: #333333; font-family: "open sans" , "sans-serif"; font-size: 13.0pt;">Pernah mengalami situs
Wordpress terjadi Error / rusak? Semua konten atau data-data anda hilang? Sekarang,
jangan lagi terjadi. Gimana caranya? <b style="mso-bidi-font-weight: normal;"><i style="mso-bidi-font-style: normal;">Manfaatkan fasilitas menu Tools Import dan
Export. </i></b>Simak<b style="mso-bidi-font-weight: normal;"><i style="mso-bidi-font-style: normal;"> </i></b>ulasan cara mengoperasikan tools
tersebut agar kedepan hati anda tenang jika terjadi Wordpress Error / rusak.<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 21.0pt; text-align: justify;">
<span style="color: #333333; font-family: "open sans" , "sans-serif"; font-size: 13.0pt;"><b><a href="https://lkpwapres.blogspot.com/2020/06/tutorial-import-eksport-konten-wordpress.html" target="_blank">KLIK DISINI</a> Tutorial Import dan Export Wordpress</b></span></div>
</div>

Amankan Konten Wordpressmu ..!!!

Pernah mengalami situs Wordpress terjadi Error / rusak? Semua konten atau data-data anda hilang? Sekarang, jangan lagi terjadi. Gimana ...

Tutorial Buat Judul Blog Berputar

<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoeAZ-WwXj7dHNP3fWVC5YejqolnMp8UuwgK33Www0BoeL2oqMu7V45ZoNU2gX8iS1IANKS3l1Gqzjvk7wo3TjZYC7vIgowlky4AAKU2etNP_I8W5Lm1cY0LW7ujXPG-mvMGzZh2lh7J_0/s1600/blogger.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="512" data-original-width="512" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoeAZ-WwXj7dHNP3fWVC5YejqolnMp8UuwgK33Www0BoeL2oqMu7V45ZoNU2gX8iS1IANKS3l1Gqzjvk7wo3TjZYC7vIgowlky4AAKU2etNP_I8W5Lm1cY0LW7ujXPG-mvMGzZh2lh7J_0/s200/blogger.png" width="200" /></a></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm; text-align: justify;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;"><b>Hello Genker's...</b></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm; text-align: justify;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">Mungkin sobat pernah melihat Blog yang Judulnya / Title </span><span style="color: #333333; font-family: "bahnschrift" , sans-serif;"> </span><span style="color: #333333; font-family: "bahnschrift" , sans-serif;">Bergerak pada Address Bar? dan anda menginginkan Blog sobat seperti itu juga? Ingin tahu cara buatnya? berikut ulasan cara pembuatannya :</span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">1. Masuk ke <i>Dashboard</i>  Blogger<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">2. Masuk ke Blog yang akan dibuat<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">3. Masuk ke <i>Template</i> / Tema<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">4. Pilih Edit Html<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">5. Cari kode atau menggunakan <b>Ctrl + F</b><o:p></o:p></span></div>
<div style="background: white; border-color: rgb(225, 225, 225) rgb(240, 240, 240) rgb(225, 225, 225) rgb(231, 76, 60); border-style: solid; border-width: 1pt 1pt 1pt 1.5pt; margin-left: 21.3pt; margin-right: 0cm; padding: 6pt 6pt 6pt 0cm;">
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 11.2pt; margin-bottom: 0.0001pt; padding: 0cm;">
<span style="color: #000088; font-family: "bahnschrift" , sans-serif;"><title><data:blog.pageTitle/></title> </span><span style="color: #333333; font-family: "bahnschrift" , sans-serif;">atau </span><span style="color: #000088; font-family: "bahnschrift" , sans-serif;"><title><o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">6. Kemudian hapus Kode tersebut</span><span style="color: #000088; font-family: "bahnschrift" , sans-serif;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">7. Di area yang dihapus tadi , Copas Kode berikut :<o:p></o:p></span></div>
<div style="background: white; border-color: rgb(225, 225, 225) rgb(240, 240, 240) rgb(225, 225, 225) rgb(231, 76, 60); border-style: solid; border-width: 1pt 1pt 1pt 1.5pt; margin-left: 21.3pt; margin-right: 0cm; padding: 6pt 6pt 6pt 0cm;">
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 11.2pt; margin-bottom: 0.0001pt; padding: 0cm;">
<i><span style="font-family: "bahnschrift" , sans-serif;"><</span></i><i><span style="color: #333333; font-family: "bahnschrift" , sans-serif;">script language='JavaScript'><o:p></o:p></span></i></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 11.2pt; margin-bottom: 0.0001pt; padding: 0cm;">
<i><span style="color: #333333; font-family: "bahnschrift" , sans-serif;">var txt=" </span></i><i><span style="color: red; font-family: "bahnschrift" , sans-serif;">GARUDA PURI > CERDAS | CERIA | BERPRESTASI</span></i><i><span style="color: #333333; font-family: "bahnschrift" , sans-serif;"> ";<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 11.2pt; margin-bottom: 0.0001pt; padding: 0cm;">
<i><span style="color: #333333; font-family: "bahnschrift" , sans-serif;">var kecepatan=120;var segarkan=null;function bergerak() { document.title=txt;<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 11.2pt; margin-bottom: 0.0001pt; padding: 0cm;">
<i><span style="color: #333333; font-family: "bahnschrift" , sans-serif;">txt=txt.substring(1,txt.length)+txt.charAt(0);<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 11.2pt; margin-bottom: 0.0001pt; padding: 0cm;">
<i><span style="color: #333333; font-family: "bahnschrift" , sans-serif;">segarkan=setTimeout("bergerak()",kecepatan);}bergerak();<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 11.2pt; margin-bottom: 0.0001pt; padding: 0cm;">
<i><span style="color: #333333; font-family: "bahnschrift" , sans-serif;"></script><o:p></o:p></span></i></div>
</div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">8. Ganti Teks </span><span style="color: red; font-family: "bahnschrift" , sans-serif;">Warna Merah</span><span style="color: #333333; font-family: "bahnschrift" , sans-serif;"> sesuai judul blog anda<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">9. Klik <b>Simpan </b></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 5.9pt 0cm;">
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">10. Selesai...... </span><span style="color: #333333; font-family: "bahnschrift" , sans-serif;">Tralalaaaaaaaa…</span><span style="color: #333333; font-family: "bahnschrift" , sans-serif;"> </span><span style="color: #333333; font-family: "bahnschrift" , sans-serif;"> </span><span style="color: #333333; font-family: "bahnschrift" , sans-serif;">Jadi dech..!!!!</span><br />
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;"><br /></span>
<span style="color: #333333; font-family: "bahnschrift" , sans-serif;">LIHAT CONTOH HASILNYA DI BLOG : </span><a href="https://garudapuri.blogspot.com/" target="_blank"><span style="font-family: "trebuchet ms" , sans-serif;"><b>https://garudapuri.blogspot.com/</b></span></a></div>

Tutorial Buat Judul Blog Berputar

Hello Genker's... Mungkin sobat pernah melihat Blog yang Judulnya / Title Bergerak pada Address Bar? dan anda menginginkan Blog ...

Visual Basic Aplication

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6Hn-VNzNh0X-Pe9P6A7XCp_7RJTNbc6wEjq59Av1wgvVQX793IGKIsfVvpN9hc9JdqkMbH31Mn-1rarozutMuANfNtFtWph0HiSBe9qaz9fdHxjSU9TIs2ABU68ELR18avnVkbVAHgwgE/s1600/VBA+EXCEL.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="362" data-original-width="548" height="211" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6Hn-VNzNh0X-Pe9P6A7XCp_7RJTNbc6wEjq59Av1wgvVQX793IGKIsfVvpN9hc9JdqkMbH31Mn-1rarozutMuANfNtFtWph0HiSBe9qaz9fdHxjSU9TIs2ABU68ELR18avnVkbVAHgwgE/s320/VBA+EXCEL.jpg" width="320" /></a></div>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<ol style="text-align: left;">
<li><a href="https://genkcomp.blogspot.com/2019/09/membuat-link-internet-pada-vba-excel.html" target=""><span style="font-family: Verdana, sans-serif;">Membuat Link URl di UserForm Microsoft Excel</span></a></li>
<li><a href="https://genkcomp.blogspot.com/2019/09/cara-membuat-menu-ribbon-sendiri-di.html"><span style="font-family: Verdana, sans-serif;">Memodifikasi Menu Ribbon Sendiri di Microsoft Excel</span></a></li>
<li><a href="https://genkcomp.blogspot.com/2019/09/membuat-teks-berjalan-pada-vba-excel.html"><span style="font-family: Verdana, sans-serif;">Membuat Teks Berjalan di UserForm</span></a></li>
</ol>
</div>

Visual Basic Aplication

Membuat Link URl di UserForm Microsoft Excel Memodifikasi Menu Ribbon Sendiri di Microsoft Excel Membuat Teks Berjalan di UserForm ...

Membuat Link URL di VBA Microsoft Excel

<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 150%;">Sobat Genk IT, disini kami sampaikan pembuatan link URL pada label pada userform di Aplikasi berbasis VBA Microsoft Excel, sehingga ketika di klik pada label tersebut akan langsung menuju ke
sebuah halaman web yang diatur. </span><br />
<span style="font-family: "arial" , sans-serif;"><br /></span>
<span style="font-family: "arial" , sans-serif;">Berikut ulasan pembuatan link URL pada label di userform :</span></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<span style="font-family: "arial" , sans-serif;">1. Masuk ke <b>Microsoft Visual Basic Excel </b>(tekan Alt+F11),</span><br />
<span style="font-family: "arial" , sans-serif;">2. Klik kanan <b>VBAProject </b><i><b>(file anda) > </b>Klik <b>Insert > </b>Pilih <b>UserForm</b></i></span><br />
<span style="font-family: "arial" , sans-serif;">3. Pada halaman <b>UserForm</b>, buatlah label dari <i>Toolbox</i></span><br />
<span style="font-family: "arial" , sans-serif;">4. Selanjutnya Klik Label tersebut, kemudian lakukan pengaturan Label di Properties </span><br />
<span style="font-family: "arial" , sans-serif;">    sebagaimana gambar berikut :</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5xCX1T__YI0cOhwafzEXkj16eYyYqZ8DKrmoBDcejJ9kuWewGRxfMyGNXdn7MsSaingT16a6nDadnJaWMeGHLfKfV8rUZ-8gc77YeNuNuOeFdLm7tN8goucOa4xuLFNwcMhrpeZleH0H-/s1600/VBA+LINK.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="557" data-original-width="800" height="443" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5xCX1T__YI0cOhwafzEXkj16eYyYqZ8DKrmoBDcejJ9kuWewGRxfMyGNXdn7MsSaingT16a6nDadnJaWMeGHLfKfV8rUZ-8gc77YeNuNuOeFdLm7tN8goucOa4xuLFNwcMhrpeZleH0H-/s640/VBA+LINK.JPG" width="640" /></a></div>
<span style="font-family: "arial" , sans-serif;"><br /></span>
<span style="font-family: "arial" , sans-serif; font-size: 12pt;">5. Double Klik Label tersebut,  kemudian </span><span style="font-family: "arial" , sans-serif; font-size: 12pt;">Ketik Kode dibawah ini  :</span><br />
<span style="font-family: "arial" , sans-serif; font-size: 12pt;">6. </span><span style="font-family: "arial" , sans-serif; font-size: 16px;">Simpan / Save (Ctrl+S)</span></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 36.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<span style="font-family: "arial" , sans-serif; font-size: 12pt;"><br /></span>
<span style="color: blue; font-family: "arial" , sans-serif;">Private Sub Label1_Click()</span><br />
<span style="font-family: "arial" , sans-serif;"><span style="color: blue;">ActiveWorkbook.FollowHyperlink "</span><b><span style="color: red;">https://genkcomp.blogspot.com/</span></b><span style="color: blue;">"</span></span><br />
<span style="color: blue; font-family: "arial" , sans-serif;">End Sub</span></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 36.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<span style="font-family: "arial" , sans-serif; font-size: 12pt;"><br /></span>
<span style="font-family: "arial" , sans-serif; font-size: 12pt;"><i><span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 24px;">Kode diatas berfungsi dengan baik (telah dicoba) ketika sebuah komputer yang terhubung dengan jaringan internet, jika ketika komputer dalam keadaan off-line , maka sebuah pesan error akan ditampilkan. </span></i></span><br />
<span style="font-family: "arial" , sans-serif; font-size: 12pt;"><i><span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 24px;">Ganti alamat URL (yang berwarna </span><span style="color: red; font-family: "arial" , "sans-serif"; font-size: 12pt; line-height: 24px;">merah</span><span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 24px;">) tersebut dengan alamat URL yang diinginkan.</span></i></span><br />
<span style="font-family: "arial" , sans-serif; font-size: 12pt;"><span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 24px;"><br /></span></span></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 150%;">7. Tekan Tobol F5 untuk menjalankan / mencoba</span><br />
<span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 150%;">8. Simpan File Excel Tipe <i>Excel Macro-Enabled Worksheet (.xlsm)</i></span><br />
<span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 150%;"><i><br /></i></span></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
</div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; line-height: 24px; margin-bottom: 0cm;">
<span style="font-family: "arial" , sans-serif; font-size: 12pt;">Contoh Label Link URL pada UserForm Login, yang kami buat untuk aplikasi VBA <b>SIAP-Desa </b><i>(sebuah aplikasi berbasis VBA Excel untuk Otomasi Pembuatan Administrasi Pengadaan Barang dan Jasa TPK Desa), silahkan unduh di </i><b><a href="https://desapanunggalan.blogspot.com/2020/06/link-download2.html" target="_blank">SIAP-DESA</a></b></span><br />
<span style="font-family: "arial" , sans-serif; font-size: 12pt;"><b>Kunci : kerjacerdas</b></span><br />
<span style="font-family: "arial" , sans-serif; font-size: 12pt;"><b>Pengguna : siap</b></span></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; line-height: 24px; margin: 0cm 0cm 0cm 18pt;">
</div>
<span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 150%;"><br /></span>
</div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 150%;"><br /></span></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 150%;"><br /></span></div>
</div>

Membuat Link URL di VBA Microsoft Excel

Sobat Genk IT, disini kami sampaikan pembuatan link URL pada label pada userform di Aplikasi berbasis VBA Microsoft Excel, sehingga ketik...

CARA MEMODIFIKASI RIBBON DI MICROSOFT EXCEL

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 7.2pt; text-align: justify; vertical-align: baseline;">
<div class="separator" style="clear: both; text-align: center;">
</div>
<div align="center" class="MsoNormal" style="background: white; line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: center; vertical-align: baseline;">
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 12.0pt; text-decoration: none;"><span style="mso-ignore: vglayout;"></span></span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify; vertical-align: baseline;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQnwdOMymek8waWCGGTOrgDUDOjbobXMI5tFD9EmTqSlJ8H-lVG45rgi_QfgASuSpmrsxWeKVOAdYuEsQLlbKD7YrdTHqqYqmSXx3lOriANSl2isbwuoa6jIL2pXAsjK1ODT7kDAUVOZJp/s1600/RIBBON+EXCEL.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="color: black;"><img border="0" data-original-height="328" data-original-width="640" height="164" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQnwdOMymek8waWCGGTOrgDUDOjbobXMI5tFD9EmTqSlJ8H-lVG45rgi_QfgASuSpmrsxWeKVOAdYuEsQLlbKD7YrdTHqqYqmSXx3lOriANSl2isbwuoa6jIL2pXAsjK1ODT7kDAUVOZJp/s320/RIBBON+EXCEL.jpg" width="320" /></span></a></div>
<br />
<div class="MsoNormal" style="background: white; line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify; vertical-align: baseline;">
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;"><b>Sobat Genk IT....</b></span><br />
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;"><b><br /></b></span>
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;"><b>Sobat pernah menggunakan aplikasi berbasis VBA Microsoft Excel? aplikasi tersebut telah memodifikasi menu ribbon Microsoft Excel? Kok Bisa? Gimana Cara membuat Menu Ribbon Di Excel tersebut? </b></span><br />
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">Memodifikasi ribbon menu di Microsoft Excel sebenarnya sangat mdah, hanya  membutuhkan tool-tool atau software tambahan tertentu dan ketekunan dan semangat untuk belajar </span><span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">saja.</span><br />
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;"><br /></span>
<b><span style="border: none 1.0pt; font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt; padding: 0cm;">Langkah-langkah
memodifikasi menu ribbon Microsoft Excel</span></b></div>
<div class="MsoNormal" style="line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">Sebelum mengunduh software Custom UI Editor, silahkan membuat
file excel yang bisa digunakan untuk menyisipkan kode macro biasanya type (excel
macro) atau extensinya .xlsm</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;"><br /></span>
<span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;">1.</span><span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;"> <span style="color: black;">Download </span><span style="color: blue;"><b><a href="https://desapanunggalan.blogspot.com/2020/06/link-download-ribbon-editor.html" target="_blank">OfficeCustomUIEditorSetup</a></b></span></span><span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;"> (size
228 kb)</span></div>
<div class="MsoNormal" style="line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 14.2pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<span style="font-family: "trebuchet ms" , sans-serif;"><span style="font-size: 14px;">Software ini freeware alias Gratis... tenang saja sob....</span></span></div>
<div class="MsoNormal" style="background: white; line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify; vertical-align: baseline;">
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">2.
Setelah terunduh, buka Software tersebut dengan aplikasi <b>Winrar</b></span></div>
<div class="MsoNormal" style="background: white; line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify; vertical-align: baseline;">
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">3. Buka
software, kemuadian double klik </span><span style="font-family: "trebuchet ms" , sans-serif; font-size: 14px;"><b>OfficeCustomUIEditorSetup.msi </b> untuk instalasi</span></div>
<div class="MsoNormal" style="background: white; line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify; vertical-align: baseline;">
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;"><br /></span>
<b><span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">Mengoperasikan </span><span style="font-family: "trebuchet ms" , sans-serif; font-size: 14px;">Office CustomUI Editor</span></b><br />
 <span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;">1.
Aktifkan Software tersebut, kemudian buka aplikasi yang akan di modif di menu </span><b style="font-family: "trebuchet ms", sans-serif; font-size: 10.5pt;">File > Open</b><span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;"> </span><br />
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">    atau klik icon Open</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEid-sZaGjW3WvhcZluMI1U1bFDMreXESZkES3k2mE132sEJJ9lQyTtAs8zgjDhrs3ukiefVYNcvJNTCbOAf_sHUdjmoIu7ICrQEEBOZBX0oizoDdKrA7ve5Dz0OIK9fVDAmDtWrE2JYD5F-/s1600/MODIF+RIBBON.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="543" data-original-width="800" height="217" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEid-sZaGjW3WvhcZluMI1U1bFDMreXESZkES3k2mE132sEJJ9lQyTtAs8zgjDhrs3ukiefVYNcvJNTCbOAf_sHUdjmoIu7ICrQEEBOZBX0oizoDdKrA7ve5Dz0OIK9fVDAmDtWrE2JYD5F-/s320/MODIF+RIBBON.JPG" width="320" /></a></div>
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;"><br /></span>
<span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;">2. Buka File Excel yang dimodifikasi (jika tidak tampil, pilih kategori <b>All Files) <i>buat latihan, silahkan</i></b></span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><b><i><span style="font-size: 10.5pt;">   unduh File SIAP Desa </span><a href="https://desapanunggalan.blogspot.com/2020/06/link-download2.html" target="_blank">DISINI</a></i></b></span><br />
<span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;">3. Akan tampil sebagai berikut (Ribbon telah dimodif), coba lakukan latihan dengan menampilkan NEW,</span><br />
<span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;">    caranya di script </span><span style="font-family: "trebuchet ms" , sans-serif;"><span style="font-size: 14px;"><button idMso="FileNew" visible="<b>false</b>"/> , falase rubahlah <b>true.</b></span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizQSodlOhPuMFCZdUjxgd0EkkPZ0nNzc2jwuCu_3M9uEponCJwJDmoYGAXMOMkmYse16vmI04DwmLhvzWX7Ht9h8Swde1S13HQkju0posDDGfzFvpw5lxcwjyiLuA4sV9MF8rtI_1QUyHn/s1600/MODIF+RIBBON+-+Copy+%25282%2529.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="555" data-original-width="800" height="222" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizQSodlOhPuMFCZdUjxgd0EkkPZ0nNzc2jwuCu_3M9uEponCJwJDmoYGAXMOMkmYse16vmI04DwmLhvzWX7Ht9h8Swde1S13HQkju0posDDGfzFvpw5lxcwjyiLuA4sV9MF8rtI_1QUyHn/s320/MODIF+RIBBON+-+Copy+%25282%2529.JPG" width="320" /></a></div>
<div class="MsoNormal" style="line-height: 17pt; margin-bottom: 0cm;">
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">4. Selanjutnya untuk mengecek klik menu <b style="mso-bidi-font-weight: normal;">validate</b></span><span style="font-family: "times new roman" , "serif"; font-size: 12pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; line-height: 17pt; margin-bottom: 0cm; vertical-align: baseline;">
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">5. Apabila sudah oke maka silahkan klik <b>simpan </b></span></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; line-height: 17pt; margin-bottom: 0cm; vertical-align: baseline;">
<span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">6. Selanjutnya Klik <b>File  > </b></span><span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;"><b>Close</b></span></div>
<span style="font-family: "trebuchet ms" , sans-serif;"><span style="font-size: 14px;">8. Kemudian Bukalah file exel tersebut, <b>tralalaaaaaaaa LIHATLAH PERUBAHANNYA...</b></span></span><br />
<div>
<br /></div>
<div>
<span style="font-family: "trebuchet ms" , sans-serif; font-size: 14px;">Silahkan mencoba, semoga bermanfaat</span></div>
</div>
<div class="MsoNormal" style="background: white; line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 14.2pt; margin-right: 0cm; margin-top: 0cm; text-align: justify; vertical-align: baseline;">
<br /></div>
</div>
</div>

CARA MEMODIFIKASI RIBBON DI MICROSOFT EXCEL

Sobat Genk IT.... Sobat pernah menggunakan aplikasi berbasis VBA Microsoft Excel? aplikasi tersebut telah memodifikasi menu ri...

praktik HTML

Berita Utama Elemen h1 digunakan untuk menandakan sebuah header dari teks (h1 == header 1). Konten teks ini sendiri berada ...

Cara Copas Data Excel pada CorelDRAW

<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-outline-level: 1;">
<span style="color: #4a4a4a; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; font-size: 9pt; text-align: justify;">Menyisipkan tabel excel
pada lembar area kerja (halaman) </span><b style="color: #4a4a4a; font-family: "Helvetica Neue", Arial, Helvetica, sans-serif; font-size: 9pt; text-align: justify;">CorelDRAW</b><span style="color: #4a4a4a; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; font-size: 9pt; text-align: justify;"> dilakukan jika kita
ingin menyertakan sebuah tabel yang kita kerjakan sebelumnya pada </span><b style="color: #4a4a4a; font-family: "Helvetica Neue", Arial, Helvetica, sans-serif; font-size: 9pt; text-align: justify;">Program
Excel.</b></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="color: #4a4a4a; font-size: 9pt;"><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Tabel yang kita kerjakan
pada program Excel hasilnya akan lebih bagus dan pengerjaannya juga lebih mudah
dibanding</span></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="color: #4a4a4a; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><span style="font-size: 12px;"><br /></span></span><span style="color: #4a4a4a; font-size: 9pt;"><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiAdo6jlXw63jMkKMuJc31GHtjbkZ5O0m22V-4IQZMNIGTMPEDYTjBd22Y4cHF9NtzAO1bnC1ujzX0mjH0tM_fML4qzfP_dezxIglkoMilWbSYyc2vnDQyvDWBxZYJ4pxx7yTKZDVaUHqW/s1600/logo_cdr_excel.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="196" data-original-width="204" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiAdo6jlXw63jMkKMuJc31GHtjbkZ5O0m22V-4IQZMNIGTMPEDYTjBd22Y4cHF9NtzAO1bnC1ujzX0mjH0tM_fML4qzfP_dezxIglkoMilWbSYyc2vnDQyvDWBxZYJ4pxx7yTKZDVaUHqW/s1600/logo_cdr_excel.jpg" /></a></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span></div>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">dengan <b>CorelDDRAW</b>, misalnya dalam hal pengaturan lebar
kolom atau tinggi garis, pengeditan angka-angka dan hasil perhitungan.<o:p></o:p></span><br />
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="color: #4a4a4a; font-size: 9pt;"><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Ini akan sangat
bermanfaat jika misalnya kita ingin menampilkan tabel hasil-hasil perhitungan
atau yang sudah kita buat di <b>Program Excel</b> tanpa harus
menuliskan ulang di <b>CorelDRAW.</b> Caranya sangat sederhana, cukup
dengan perintah <b>Copy</b> dan <b>Paste</b> saja.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="color: #4a4a4a; font-size: 9pt;"><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Langkah-langkah yang kita
lakukan adalah:<br />
Buka file <b>Excel</b> dimana terdapat tabel yang ingin kita sertakan
pada file <b>CorelDRAW</b>;<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 12.0pt; text-align: justify;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><span style="color: #4a4a4a; font-size: 9pt;"><br />
</span><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMtWEU_93n4_xbLKCKAmhpNmmvUpeINfIdPH6lQWXKEvW8cHfGUuDyS1Qy179lj-gTR0X_JJrm0Xx8uF0j2I4LmUaOpkITd8F2EtQms4bzpIalTn-1erkhPjH_GWoG1WaL8guRWfOZ_iOZ/s1600/1.jpg"><span style="color: #ed008c; font-size: 9pt; text-decoration: none;"><span style="mso-ignore: vglayout;"></span></span></a><span style="color: #4a4a4a; font-size: 9pt;"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="color: #4a4a4a; font-size: 9pt;"><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Blok area tabel yang akan
kita ambil;<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><span style="color: #ed008c; font-size: 9pt; text-decoration: none;"><span style="mso-ignore: vglayout;"></span></span><span style="color: #4a4a4a; font-size: 9pt;"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 12.0pt; text-align: justify;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><span style="color: #4a4a4a; font-size: 9pt;">Klik kanan dan pilih <b>Copy</b> (atau cukup tekan
tombol <b>Ctrl+C</b>), maka akan tampak garis putus-putus pada area tabel
yang kita <b>Copy</b>;<br />
<br />
</span><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMPJqIPVUb8s_bxB_sl7yD2RZcW3DlQUVDwiQhwwK4P9502_OM-QIeyNh7M4irsoM47FUzHg-zXt1Q8Iaa8pmWSA7eXWnu0YfJIvCpJ7Lae4RHcb_olrZLz-Tq8wIi5gsSsZ58fsjdTQwz/s1600/3.jpg"><span style="color: #ed008c; font-size: 9pt; text-decoration: none;"><span style="mso-ignore: vglayout;"></span></span></a><span style="color: #4a4a4a; font-size: 9pt;"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="color: #4a4a4a; font-size: 9pt;"><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Masuk kepada
halaman <b>CorelDRAW</b> dimana tabel tersebut ingin kita sisipkan<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><span style="color: #4a4a4a; font-size: 9pt;">Pada <b>Menu Bar</b> -->
klik <b>Edit</b> --> <b>Paste Special...</b><br />
<br />
 </span><span style="color: #ed008c; font-size: 9pt; text-decoration: none;"><span style="mso-ignore: vglayout;"></span></span><span style="color: #4a4a4a; font-size: 9pt;"><br />
<br />
Akan muncul Kotak Dialog menu <b>Paste Special.</b><o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBOHO5_2RDIBqJdXdqVLHDQcUqGj8z-TMjbgOTNym8-NLrM60gfS-bLeSBBpKU69x2IFJQ1liXDJe__ItwsL23mwe8-mg7AxL8OTdsFYrMQgwY3Wr5foRujw03OzqoqbbRS62fC6jS0DKs/s1600/5.jpg"><span style="color: #ed008c; font-size: 9pt; text-decoration: none;"><span style="mso-ignore: vglayout;"></span></span></a><span style="color: #4a4a4a; font-size: 9pt;"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="color: #4a4a4a; font-size: 9pt;"><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Pada menu <b>Paste
Special</b> tersebut terdapat pilihan <b>Paste</b> dan <b>Paste
Link.</b><o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="color: #4a4a4a; font-size: 9pt;"><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Jika ingin isi tabel yang
kita sisipkan adalah sebagaimana adanya tabel pada saat itu, maka aktifkan
pilihan <b>Paste</b>.<br />
Jika ingin tabel yang kita sisipkan akan link dengan tabel yang ada pada file
Excel-nya, aktifkan pilihan P<b>aste Link.</b><o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="color: #4a4a4a; font-size: 9pt;"><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Pada pilihan Paste, di
sebelah kanannya akan ada pilihan-pilihan tabel yang ingin kita sisipkan itu
diperlakukan sebagai Microsoft Excel Worksheet, sebagai gambar (picture atau
bitmap) atau sebagai text. Agar dia tetap sebagai tabel pilihlah Microsoft
Excel Worksheet.<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="color: #4a4a4a; font-size: 9pt;"><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"> Klik <b>OK</b><o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="color: #4a4a4a; font-size: 9pt;"><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Arahkan pointer pada Area
Kerja <b>CorelDRAW</b> dimana tabel tersebut akan kita tempatkan dan
klik mouse di sana, hasilnya akan seperti gambar dibawah;<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 12.0pt; text-align: justify;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><span style="color: #4a4a4a; font-size: 9pt;"><br />
</span><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh45NgBFkGIZhWNodME5f9ekngKG-rNDPVe3HTyjdJ3oi1mD7Rfd6OnQAfZRsHAzo2h67lUgRkSjU-G8JX9fn-eGwkjnl-eiKDgq9zZhQ60NruUcXhUggTrCNZRzwbfWsJBCx8DSztyd7Bb/s1600/6.jpg"><span style="color: #ed008c; font-size: 9pt; text-decoration: none;"><span style="mso-ignore: vglayout;"></span></span></a><span style="color: #4a4a4a; font-size: 9pt;"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 12.0pt; text-align: justify;">
<span style="color: #4a4a4a; font-size: 9pt;"><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Dengan langkah-langkah tersebut, maka setiap kali kita melakukan
editing pada tabel tersebut, maka kita akan masuk pada menu-menu seperti
pada <b>Program Excel.</b> Kitapun bisa melakukan perintah-perintah
seperti pengaturan lebar kolom atau tinggi baris, memasukkan formula, mengubah
nilai-nilai, dsb, caranya dobel klik pada tabel hasil <b>Paste Link</b> yang
ada pada Area Kerja <b>CorelDRAW</b> maka kita diarahkan pada <b>Program
Excel</b> kemudian edit apa yang mau kita rubah;<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirbKnSQ5nkg_5it_64kwQXy5SmKuqdL2IXbbmpe6uRUrNk8ByrZNxOxmUJuTl7bTEfMVoaM-UU5YUKMUoRf2KBaPDtj2-QG8dgj5IVay9Y6fXmGgWlsxg9n6vLH3qaefSAfyWPMgj8yIWG/s1600/7.jpg"><span style="color: #ed008c; font-size: 9pt; text-decoration: none;"><span style="mso-ignore: vglayout;"></span></span></a><span style="color: #4a4a4a; font-size: 9pt;"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><span style="color: #4a4a4a; font-size: 9pt;">Dan kita kembali ke <b>CorelDRAW</b>,
maka tabel juga sudah mengalamu perubahan<br />
<br />
</span><span style="color: #ed008c; font-size: 9pt; text-decoration: none;"><span style="mso-ignore: vglayout;"></span></span><span style="color: #4a4a4a; font-size: 9pt;"><br />
<br />
Jika telah selesai, klik pada area di luar tabel tersebut dan kita akan kembali
kepada menu-menu pada <b>CorelDRAW</b>.<o:p></o:p></span></span></div>
<div class="MsoNormal">
<br /></div>
<br /></div>

Cara Copas Data Excel pada CorelDRAW

Menyisipkan tabel excel pada lembar area kerja (halaman) CorelDRAW dilakukan jika kita ingin menyertakan sebuah tabel yang kita kerjaka...

Mengenal HTML Dasar

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-7mMMme8fngfMD3tE-IH9qxR7kXm96ickZJE_Sb_hotKtDUevmIkD-9ua5A156J2LDRYafEfLZVsIVkCqleqN2Gq7FN8yegN98yHbb7NCSAFlR0-YyTCFlHXLsZHIYyK6dmIBqJH3XG_T/s1600/what-is-html.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="276" data-original-width="640" height="138" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-7mMMme8fngfMD3tE-IH9qxR7kXm96ickZJE_Sb_hotKtDUevmIkD-9ua5A156J2LDRYafEfLZVsIVkCqleqN2Gq7FN8yegN98yHbb7NCSAFlR0-YyTCFlHXLsZHIYyK6dmIBqJH3XG_T/s320/what-is-html.jpg" width="320" /></a></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-outline-level: 1;">
<span style="font-family: "verdana" , sans-serif; text-align: justify;">HTML adalah sebuah bahasa markup
standar singkatan dari <em style="box-sizing: inherit;">Hyper Text Markup Language</em>.
</span><b style="text-align: justify;"><span style="font-family: "verdana" , "sans-serif"; mso-bidi-font-family: "Open Sans";">HTML</span></b><span style="font-family: "verdana" , sans-serif; text-align: justify;"> merupakan bahasa penanda yang digunakan
untuk memberikan konten (teks) struktur dan makna semantik.</span></div>
<div style="background: white; margin-bottom: .0001pt; margin: 0cm; text-align: justify;">
<span style="font-family: "verdana" , "sans-serif";">Dengan HTML di Web Browser memungkinakan
untuk menampilkan informasi. untuk melihat kode HTML klik kanan kemudian pilih <i>Lihat Sumber Halaman</i> <em>/ View page source (ctrl+u).<o:p></o:p></em></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">HTML memiliki fungsi sebagai pondasi
sebuah halaman website. HTML memiliki fungsi lain sebagai berikut ini.
Membungkus element element tertentu sesuai dengan kebutuhan.<o:p></o:p></span></div>
<ul style="margin-top: 0cm;" type="disc">
<li class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-align: justify;"><span style="font-family: "verdana" , sans-serif;">Membuat
     heading atau Judul.<o:p></o:p></span></li>
<li class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-align: justify;"><span style="font-family: "verdana" , sans-serif;">Membuat
     tabel.<o:p></o:p></span></li>
<li class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-align: justify;"><span style="font-family: "verdana" , sans-serif;">Membuat
     list.<o:p></o:p></span></li>
<li class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-align: justify;"><span style="font-family: "verdana" , sans-serif;">Membuat
     paragraf.<o:p></o:p></span></li>
<li class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-align: justify;"><span style="font-family: "verdana" , sans-serif;">Membuat
     Form.<o:p></o:p></span></li>
<li class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-align: justify;"><span style="font-family: "verdana" , sans-serif;">Membuat
     tombol.<o:p></o:p></span></li>
<li class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-align: justify;"><span style="font-family: "verdana" , sans-serif;">Membuat
     huruf menjadi tebal.<o:p></o:p></span></li>
<li class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-align: justify;"><span style="font-family: "verdana" , sans-serif;">Membuat
     huruf menjadi miring.<o:p></o:p></span></li>
<li class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-align: justify;"><span style="font-family: "verdana" , sans-serif;">Menampilkan
     gambar.<o:p></o:p></span></li>
<li class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt; text-align: justify;"><span style="font-family: "verdana" , sans-serif;">Menampilakan
     video.<o:p></o:p></span></li>
</ul>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Dan masih banyak lagi yang bisa di buat
oleh bahasa HTML. Saat ini HTML sudah sampai pada versi 5. HTML5 sudah memiliki
banyak sekali fitur tambahan.</span></div>
<div style="background: white; margin-bottom: .0001pt; margin: 0cm; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<b><span style="font-family: "verdana" , sans-serif;">Elemen,
Tag, dan Atribut<o:p></o:p></span></b></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Merupakan tiga istilah utama yang harus
diketahui ketika menulis kode HTML. Ketiga istilah tersebut adalah <b><i>elemen,
tag, dan atribut</i></b>.<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<b><span style="font-family: "verdana" , sans-serif;">Elemen<o:p></o:p></span></b></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Elemen HTML merupakan komponen yang
menetapkan peran sebuah objek dalam dokumen, termasuk struktur dan konten dari
objek tersebut. Contoh dari sebuah elemen HTML ialah <b>p</b> ataupun <b>b </b>.
Elemen-elemen populer lain dalam HTML misalnya <b>a, h1, div, span, em, </b>ataupun<b> strong.<o:p></o:p></b></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<b><span style="font-family: "verdana" , sans-serif;">Tag<o:p></o:p></span></b></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Sebuah elemen biasanya direpresentasikan oleh
<b>tag</b>. <b>Tag pembuka</b> menandakan elemen tersebut dimulai, dan <b>tag penutup</b> menandakan akhir dari
sebuah elemen. Tag pembuka direpresentasikan dengan nama elemen yang diapit
simbol “<b><></b>”, contohnya <b><a>. </b>Tag penutup dituliskan
dengan menambahkan <b>garis miring ( / ) </b>setelah
simbol<b> ( < ).</b> Misalnya, tag
penutup untuk elemen <b>a </b>adalah <b></a>.<o:p></o:p></b></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<b><span style="font-family: "verdana" , sans-serif;">Atribut<o:p></o:p></span></b></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Atribut merupakan informasi tambahan untuk
sebuah elemen. Setiap elemen memiliki atribut yang berbeda-beda, meskipun
terdapat beberapa atribut standar yang dapat digunakan oleh semua elemen.<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<b><span style="font-family: "verdana" , sans-serif;">Atribut khusus elemen</span></b><span style="font-family: "verdana" , sans-serif;"> dibuat ketika nilai
atribut tersebut memang hanya digunakan untuk elemen tertentu. Misalnya, untuk
elemen <b><i>img </i></b><i>yang digunakan
untuk menampilkan gambar </i>atribut ini tidak akan berguna untuk elemen <b>p</b> yang hanya untuk menampilkan teks.
Contoh lain adalah elemen <b>“a” </b>dengan
atribut wajib “<b>href” </b><i>untuk menampilkan link</i>.<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Atribut
standar yang dimiliki oleh semua elemen sendiri merupakan atribut yang umumnya
dapat diimplementasikan oleh semua elemen, misalnya atribut <b>“id”</b> <i>untuk identifikasi elemen</i>, atau <b>“class” </b><i>untuk klasifikasi
elemen</i>.<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Contoh
Elemen, Tag dan Atribut :<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 0cm 0cm 0.0001pt 14.2pt; text-align: justify;">
<span class="html-tag"><b><span style="font-family: "verdana" , sans-serif;"><a
</span></b></span><span class="html-attribute-name"><b><span style="font-family: "verdana" , sans-serif;">href</span></b></span><span class="html-tag"><b><span style="font-family: "verdana" , sans-serif;">="<a href="http://genkcomp.blogspot.com/" target="_blank"><span style="color: windowtext;">http://genkcomp.blogspot.com/</span></a>"></span><span style="white-space: pre-wrap;"> </span></b></span><b><span style="font-family: "verdana" , sans-serif;">BLOG GENK IT <span class="html-tag"></a></span><o:p></o:p></span></b></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin: 0cm 0cm 0.0001pt 14.2pt; text-align: justify;">
<br /></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOVcIIYV2VQKt1wtmAInzCepY5Eo02tsayMTS3y9TxpkaswzUrNPz8_Ng4e9VmwyEsJ2K_PzoKQBLtROC4P0TUAnLqxI5t6H8GZ87VR3c3_Qa29sLjaq3T7AE4iB0-qx_RArncpoHiEcI5/s1600/HTML+1.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="210" data-original-width="800" height="105" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOVcIIYV2VQKt1wtmAInzCepY5Eo02tsayMTS3y9TxpkaswzUrNPz8_Ng4e9VmwyEsJ2K_PzoKQBLtROC4P0TUAnLqxI5t6H8GZ87VR3c3_Qa29sLjaq3T7AE4iB0-qx_RArncpoHiEcI5/s400/HTML+1.PNG" width="400" /></a></div>
<div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 0.0001pt; text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="background-color: white; font-family: "verdana" , sans-serif;">Referensi Artikel : </span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Coding HTML dll ---> <a href="https://www.w3schools.com/">https://www.w3schools.com/</a></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Diskusi Coding   ---> <a href="https://stackoverflow.com/">https://stackoverflow.com/</a></span></div>
<div style="text-align: justify;">
<span style="font-family: "verdana" , sans-serif;">Daftar Warna     ---> <a href="https://id.wikipedia.org/wiki/Daftar_warna">https://id.wikipedia.org/wiki/Daftar_warna</a></span></div>
</div>

Mengenal HTML Dasar

HTML adalah sebuah bahasa markup standar singkatan dari Hyper Text Markup Language . HTML merupakan bahasa penanda yang digunakan untu...

Membuat Teks Berjalan pada VBA Excel

<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQAGOEpw1tvNEE11bk1xTwNxwqNSskCa86npgZkv7zTo5cW4AT6TQPhDmj-I8GCWsuXvmAgyK0q34-1Q7CWzY5yuSZSjBO-u2XF6nbg4BH6PDS-WNEzF5uefxwI1ExmxEgeSGzeg6G756j/s1600/VBA+EXCEL.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="362" data-original-width="548" height="211" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQAGOEpw1tvNEE11bk1xTwNxwqNSskCa86npgZkv7zTo5cW4AT6TQPhDmj-I8GCWsuXvmAgyK0q34-1Q7CWzY5yuSZSjBO-u2XF6nbg4BH6PDS-WNEzF5uefxwI1ExmxEgeSGzeg6G756j/s320/VBA+EXCEL.jpg" width="320" /></a></div>
<span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">Bagi programmer VBA Excel yang kesulitan
membuat Teks Berjalan pada VB Excel yang berfungsi untuk langsung menuju ke
sebuah halaman website (browser <i>default</i> tergantung dari
pengaturan user komputer). </span><span style="font-family: "arial" , sans-serif; font-size: 12pt;">Pada artikel ini dapat mempelajari cara
membuat Teks Berjalan pada VBA Excel (Alt+F11). Contoh berikut ini berupa Label
Form Login (Label 8), caranya :</span></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">Double Klik <b>Label </b><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">Ketik Kode berikut ini <span style="mso-spacerun: yes;"> </span>:<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">Private Sub
Label8_Click()<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">Option Explicit<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">Dim Stopped As Boolean<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><span style="mso-spacerun: yes;">   </span>If Stopped Then<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><span style="mso-spacerun: yes;">      </span>Stopped = False<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><span style="mso-spacerun: yes;">      </span>Jalankan<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><span style="mso-spacerun: yes;">   </span>Else<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><span style="mso-spacerun: yes;">      </span>Stopped = True<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><span style="mso-spacerun: yes;">   </span>End If<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">End Sub<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">Private Sub
UserForm_Activate()<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">Jalankan<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">End Sub<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">Private Sub Jalankan()<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><span style="mso-spacerun: yes;">   </span>Dim Q As String, Cpt As String<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><span style="mso-spacerun: yes;">   </span>Dim p As Long, n As Long<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><span style="mso-spacerun: yes;">   </span>Q = "</span><span style="font-family: "arial" , sans-serif; font-size: 12pt; line-height: 150%;"><span style="color: red;">SELAMAT MENGGUNAKAN APLIKASI
SIAP-DESA, MARI WUJUDKAN KERJA CERDAS</span></span><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">"<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><span style="mso-spacerun: yes;">   </span>Label8 = Q<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><span style="mso-spacerun: yes;">   </span>n = Len(Q)<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><span style="mso-spacerun: yes;">   </span>Cpt = Space(60) & Q<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">AWAL:<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><span style="mso-spacerun: yes;">   </span>DoEvents<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><span style="mso-spacerun: yes;">   </span>If Stopped = True Then Exit Sub<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><span style="mso-spacerun: yes;">   </span>Label8.Left = Label8.Left - 2<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><span style="mso-spacerun: yes;">   </span>If Label8.Left <= -Me.Width Then
Label8.Left = Me.Width<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><span style="mso-spacerun: yes;">   </span>'Me.Caption = Right(Cpt, n) DI HAPUS<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><span style="mso-spacerun: yes;">   </span>n = n + 1<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><span style="mso-spacerun: yes;">   </span>If n = (Len(Q) + 60) Then n = 0<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><span style="mso-spacerun: yes;">     </span>For p = 1 To 5000000: Next<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><span style="mso-spacerun: yes;">   </span>GoTo AWAL<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<i style="mso-bidi-font-style: normal;"><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">End Sub<o:p></o:p></span></i></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 18.0pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;">
<span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">Klik <b>Simpan / Save</b><o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><br />
Kode diatas berfungsi dengan baik (telah dicoba) Ganti Teks yang berwarna </span><span style="color: red; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">merah</span><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"> tersebut dengan alamat teks yang diinginkan. Selamat mencoba.<o:p></o:p></span></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><br /></span></div>
<div class="MsoNormal" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;">
<span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><b><i><a href="https://api.whatsapp.com/send?phone=6285233336228&text=&source=&data=" target="_blank">Man Jadda Wajada</a></i></b></span></div>
<br /></div>

Membuat Teks Berjalan pada VBA Excel

Bagi programmer VBA Excel yang kesulitan membuat Teks Berjalan pada VB Excel yang berfungsi untuk langsung menuju ke sebuah halaman web...

Menghilangkan #N/A pada Fungsi VLOOKUP Excel

<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 class="post-title entry-title" itemprop="name" style="border-bottom-color: rgb(204, 204, 204); border-bottom-style: solid; border-image: initial; border-left-color: initial; border-left-style: initial; border-right-color: initial; border-right-style: initial; border-top-color: initial; border-top-style: initial; border-width: 0px 0px 1px; box-sizing: border-box; color: #00a650; font-family: inherit; font-size: 1.3846rem; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: 700; line-height: 1.4; margin: 0px 0px 0.85715em; overflow-wrap: break-word; padding: 0px; vertical-align: baseline;">
<div class="MsoListParagraphCxSpFirst" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 1.0cm; margin-right: 0cm; margin-top: 0cm; mso-add-space: auto; mso-list: l0 level1 lfo1; mso-outline-level: 2; text-indent: -25.05pt; vertical-align: baseline;">
<b><span style="color: #17375e; font-family: "arial" , "sans-serif"; font-size: 14.0pt; line-height: 150%;"><span style="mso-list: Ignore;"><br /></span></span></b></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiV3fY_QBDTyUAHWmJMCE_empnprhQrnDmUHXRlgYQP0CuunEGy13kgqiifUvkXHop26YGY7UMqF9_ASKVerNStZ7rQxoXinZGjnWmONRsysq1yqlD1iYeUM-QZnMaf9H0-1M_hLPRnmsQI/s1600/ERROR.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="720" data-original-width="693" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiV3fY_QBDTyUAHWmJMCE_empnprhQrnDmUHXRlgYQP0CuunEGy13kgqiifUvkXHop26YGY7UMqF9_ASKVerNStZ7rQxoXinZGjnWmONRsysq1yqlD1iYeUM-QZnMaf9H0-1M_hLPRnmsQI/s200/ERROR.png" width="192" /></a></div>
<div class="MsoListParagraphCxSpFirst" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 1.0cm; margin-right: 0cm; margin-top: 0cm; mso-add-space: auto; mso-list: l0 level1 lfo1; mso-outline-level: 2; text-indent: -25.05pt; vertical-align: baseline;">
<b><span style="color: #17375e; font-family: "arial" , "sans-serif"; font-size: 14.0pt; line-height: 150%;"><span style="mso-list: Ignore;"><br /></span></span></b></div>
<div class="MsoListParagraphCxSpFirst" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 1.0cm; margin-right: 0cm; margin-top: 0cm; mso-add-space: auto; mso-list: l0 level1 lfo1; mso-outline-level: 2; text-indent: -25.05pt; vertical-align: baseline;">
<b style="font-family: inherit; font-size: 1.3846rem; font-style: inherit; font-variant-caps: inherit; font-variant-ligatures: inherit; text-indent: -25.05pt;"><span style="color: #17375e; font-family: "arial" , "sans-serif"; font-size: 14.0pt; line-height: 150%;">1.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; font-weight: normal; line-height: normal;">     
</span></span></b><span dir="LTR" style="font-family: inherit; font-size: 1.3846rem; font-style: inherit; text-indent: -25.05pt;"></span><b style="font-family: inherit; font-size: 1.3846rem; font-style: inherit; font-variant-caps: inherit; font-variant-ligatures: inherit; text-indent: -25.05pt;"><span style="color: #17375e; font-family: "arial" , "sans-serif"; font-size: 14.0pt; line-height: 150%;">Menghilangkan Error #N/A pada Excel 2007/2010</span></b></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 1.0cm; margin-right: 0cm; margin-top: 0cm; mso-add-space: auto; mso-outline-level: 2; vertical-align: baseline;">
<span lang="IN" style="background: white; color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">Pada Microsoft Excel 2007,2010, </span><span style="background: white; color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">menggunakan
fungsi penanganan error lainnya yaitu IFERROR. </span><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><br />
<br />
<span style="background: white;">Fungsi IFERROR bisa digunakan untuk menangani
semua masalah rumus error di Microsoft Excel termasuk juga error #N/A.
Penulisannya rumusnya pun hampir sama dengan IFNA yaitu:</span><br style="mso-special-character: line-break;" />
<br style="mso-special-character: line-break;" />
</span><b><span lang="IN" style="color: #00a650; font-family: "arial" , "sans-serif"; font-size: 18.0pt; line-height: 150%;"><o:p></o:p></span></b></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 1.0cm; margin-right: 0cm; margin-top: 0cm; mso-add-space: auto; mso-outline-level: 2; vertical-align: baseline;">
<span style="background: white; color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">Untuk
penerapan IFERROR pada fungsi VLOOKUP caranya adalah sebagai berikut</span><span style="background: white; color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"> </span><span style="background: white; color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">:</span><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><br />
<span style="background: white;">Misal rumus sel C14 adalah</span></span><span lang="IN" style="background: white; color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"> :<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 1.0cm; margin-right: 0cm; margin-top: 0cm; mso-add-space: auto; mso-outline-level: 2; vertical-align: baseline;">
<span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><br />
</span><span style="color: #222222; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">=</span><span style="border: none 1.0pt; color: red; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%; padding: 0cm;">IFERROR</span><span style="color: #222222; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">(VLOOKUP(C13;B5:D9;2;FALSE)</span><span style="border: none 1.0pt; color: red; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%; padding: 0cm;">;"")</span><span lang="IN" style="border: none 1.0pt; color: red; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%; padding: 0cm;"><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 1.0cm; margin-right: 0cm; margin-top: 0cm; mso-add-space: auto; mso-outline-level: 2; text-align: justify; vertical-align: baseline;">
<i><span style="background: white; color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">Hasilnya jika data tidak ada maka sel C14 tidak
akan menampilkan apa-apa (kosong).</span></i><i><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><br style="mso-special-character: line-break;" />
<br style="mso-special-character: line-break;" />
</span></i><b><i><span style="color: #00a650; font-family: "arial" , "sans-serif"; font-size: 18.0pt; line-height: 150%;"><o:p></o:p></span></i></b></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 1.0cm; margin-right: 0cm; margin-top: 0cm; mso-add-space: auto; mso-list: l0 level1 lfo1; mso-outline-level: 2; text-indent: -25.05pt; vertical-align: baseline;">
<b><span style="color: #17375e; font-family: "arial" , "sans-serif"; font-size: 14.0pt; line-height: 150%;"><span style="mso-list: Ignore;">2.<span style="font: 7.0pt "Times New Roman";">     
</span></span></span></b><span dir="LTR"></span><b><span style="color: #17375e; font-family: "arial" , "sans-serif"; font-size: 14.0pt; line-height: 150%;">Menghilangkan Error #N/A pada Excel 2003<o:p></o:p></span></b></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 1.0cm; margin-right: 0cm; margin-top: 0cm; mso-add-space: auto; mso-outline-level: 2; vertical-align: baseline;">
<span lang="IN" style="background: white; color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">Pada Microsoft </span><span style="background: white; color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">Excel 2003, menggunakan fungsi ISERROR. </span><span style="color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><br />
<br />
<span style="background: white;">Bentuk Penulisan sintaksisnya adalah:</span><br style="mso-special-character: line-break;" />
<br style="mso-special-character: line-break;" />
</span><span lang="IN" style="color: #222222; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 1.0cm; margin-right: 0cm; margin-top: 0cm; mso-add-space: auto; mso-outline-level: 2; vertical-align: baseline;">
<span style="color: #222222; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">=</span><span style="border: none 1.0pt; color: red; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%; padding: 0cm;">IF(ISERROR</span><span style="color: #222222; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">(VLOOKUP(C13;B5:D9;2;FALSE)</span><span style="border: none 1.0pt; color: red; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%; padding: 0cm;">);"";</span><span style="color: #222222; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;"><br />
VLOOKUP(C13;B5:D9;2;FALSE)</span><span style="border: none 1.0pt; color: red; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%; padding: 0cm;">)</span><span lang="IN" style="border: none 1.0pt; color: red; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%; padding: 0cm;"><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="background: white; line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 1.0cm; margin-right: 0cm; margin-top: 0cm; mso-add-space: auto; mso-outline-level: 2; vertical-align: baseline;">
<i><span style="background: white; color: black; font-family: "arial" , "sans-serif"; font-size: 12.0pt; line-height: 150%;">Hasilnya
jika data tidak ada maka sel C14 tidak akan menampilkan apa-apa (kosong).</span></i><b><i><span style="color: #17375e; font-family: "arial" , "sans-serif"; font-size: 14.0pt; line-height: 150%;"><o:p></o:p></span></i></b></div>
</h2>
<div>
Sumber Referensi : <a href="https://www.rumusexcel.com/2015/03/3-cara-menghilangkan-n-a-pada-fungsi-vlookup-excel.html">https://www.rumusexcel.com/2015/03/3-cara-menghilangkan-n-a-pada-fungsi-vlookup-excel.html</a></div>
</div>

Menghilangkan #N/A pada Fungsi VLOOKUP Excel

1. Menghilangkan Error #N/A pada Excel 2007/2010 Pada Microsoft Excel 2007,2010, menggunakan fungsi penanganan error lainny...