GENK IT

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

Membuat Teks Berjalan pada VBA Excel

Menghilangkan #N/A pada Fungsi VLOOKUP Excel

Pos Unggulan

ARSIP