GENK IT

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...

Mengenal HTML Dasar

Membuat Teks Berjalan pada VBA Excel

Menghilangkan #N/A pada Fungsi VLOOKUP Excel

Pos Unggulan

ARSIP