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

Read more »

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;"><!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"> <v:stroke joinstyle="miter"/> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"/> <v:f eqn="sum @0 1 0"/> <v:f eqn="sum 0 0 @1"/> <v:f eqn="prod @2 1 2"/> <v:f eqn="prod @3 21600 pixelWidth"/> <v:f eqn="prod @3 21600 pixelHeight"/> <v:f eqn="sum @0 0 1"/> <v:f eqn="prod @6 1 2"/> <v:f eqn="prod @7 21600 pixelWidth"/> <v:f eqn="sum @8 21600 0"/> <v:f eqn="prod @7 21600 pixelHeight"/> <v:f eqn="sum @10 21600 0"/> </v:formulas> <v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/> <o:lock v:ext="edit" aspectratio="t"/> </v:shapetype><v:shape id="Picture_x0020_3" o:spid="_x0000_i1025" type="#_x0000_t75" alt="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXQF1MqV25gLDiraeoYfudlQRjEJhX3O5aMS9TnBKHn4AegIR61-uLjKx0_IMQQagVEpGIhyPIJRgmLOdksJuVC_FoB1yue2wPyRyOI9y4kEW6G_i_OnvsShoDxjCGBKJPGIt9gQqoBnJu/s320/RIBBON+EXCEL.jpg" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXQF1MqV25gLDiraeoYfudlQRjEJhX3O5aMS9TnBKHn4AegIR61-uLjKx0_IMQQagVEpGIhyPIJRgmLOdksJuVC_FoB1yue2wPyRyOI9y4kEW6G_i_OnvsShoDxjCGBKJPGIt9gQqoBnJu/s1600/RIBBON+EXCEL.jpg" style='width:240pt;height:122.25pt;visibility:visible;mso-wrap-style:square' o:button="t"> <v:imagedata src="file:///C:\Users\DESAPA~1\AppData\Local\Temp\msohtmlclip1\01\clip_image001.jpg" o:title="RIBBON%2BEXCEL"/> </v:shape><![endif]--><!--[if !vml]--><span style="mso-ignore: vglayout;"></span><!--[endif]--></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...

Read more »

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;"><!--[if gte vml 1]><v:shape id="Picture_x0020_8" o:spid="_x0000_i1032" type="#_x0000_t75" alt="Description: https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMtWEU_93n4_xbLKCKAmhpNmmvUpeINfIdPH6lQWXKEvW8cHfGUuDyS1Qy179lj-gTR0X_JJrm0Xx8uF0j2I4LmUaOpkITd8F2EtQms4bzpIalTn-1erkhPjH_GWoG1WaL8guRWfOZ_iOZ/s1600/1.jpg" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMtWEU_93n4_xbLKCKAmhpNmmvUpeINfIdPH6lQWXKEvW8cHfGUuDyS1Qy179lj-gTR0X_JJrm0Xx8uF0j2I4LmUaOpkITd8F2EtQms4bzpIalTn-1erkhPjH_GWoG1WaL8guRWfOZ_iOZ/s1600/1.jpg" style='width:232.5pt;height:266.25pt;visibility:visible;mso-wrap-style:square' o:button="t"> <v:imagedata src="file:///C:\Users\LENOVO\AppData\Local\Temp\msohtmlclip1\01\clip_image003.jpg" o:title="1"/> </v:shape><![endif]--><!--[if !vml]--><span style="mso-ignore: vglayout;"></span><!--[endif]--></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;"><!--[if gte vml 1]><v:shape id="Picture_x0020_7" o:spid="_x0000_i1031" type="#_x0000_t75" alt="Description: https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUgrc-uNbR02rNEJZ5b11XVH9njJQSvV6b50z1Oq1Avt4GSbYeh5sf20YwIpW8DlR4JnY4f08XTdncTkWKdnpkWmRWY2UrAAU6-mcYR8-40bJvGsF45aSG6Hjf7QAwQCXlB8-9TjbGEabU/s1600/2.jpg" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUgrc-uNbR02rNEJZ5b11XVH9njJQSvV6b50z1Oq1Avt4GSbYeh5sf20YwIpW8DlR4JnY4f08XTdncTkWKdnpkWmRWY2UrAAU6-mcYR8-40bJvGsF45aSG6Hjf7QAwQCXlB8-9TjbGEabU/s1600/2.jpg" style='width:230.25pt;height:270pt;visibility:visible;mso-wrap-style:square' o:button="t"> <v:imagedata src="file:///C:\Users\LENOVO\AppData\Local\Temp\msohtmlclip1\01\clip_image004.jpg" o:title="2"/> </v:shape><![endif]--><!--[if !vml]--><span style="mso-ignore: vglayout;"></span><!--[endif]--></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;"><!--[if gte vml 1]><v:shape id="Picture_x0020_6" o:spid="_x0000_i1030" type="#_x0000_t75" alt="Description: https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMPJqIPVUb8s_bxB_sl7yD2RZcW3DlQUVDwiQhwwK4P9502_OM-QIeyNh7M4irsoM47FUzHg-zXt1Q8Iaa8pmWSA7eXWnu0YfJIvCpJ7Lae4RHcb_olrZLz-Tq8wIi5gsSsZ58fsjdTQwz/s1600/3.jpg" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMPJqIPVUb8s_bxB_sl7yD2RZcW3DlQUVDwiQhwwK4P9502_OM-QIeyNh7M4irsoM47FUzHg-zXt1Q8Iaa8pmWSA7eXWnu0YfJIvCpJ7Lae4RHcb_olrZLz-Tq8wIi5gsSsZ58fsjdTQwz/s1600/3.jpg" style='width:229.5pt;height:270pt;visibility:visible;mso-wrap-style:square' o:button="t"> <v:imagedata src="file:///C:\Users\LENOVO\AppData\Local\Temp\msohtmlclip1\01\clip_image005.jpg" o:title="3"/> </v:shape><![endif]--><!--[if !vml]--><span style="mso-ignore: vglayout;"></span><!--[endif]--></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;"><!--[if gte vml 1]><v:shape id="Picture_x0020_5" o:spid="_x0000_i1029" type="#_x0000_t75" alt="Description: https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjz5J8FrR4xFk8MwZ2Smfvgx7cc-p9BkWT5soy0xfrgCZN7Qc6cotxUThmZkBmZvfuh76hHbSNFfip-ADmzi865uWawPkAa7KSDKmIUhEtJ8Rkx4UPfGpdvVZwsf5FNjnV9o07PUZ_XxnNB/s1600/4.jpg" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjz5J8FrR4xFk8MwZ2Smfvgx7cc-p9BkWT5soy0xfrgCZN7Qc6cotxUThmZkBmZvfuh76hHbSNFfip-ADmzi865uWawPkAa7KSDKmIUhEtJ8Rkx4UPfGpdvVZwsf5FNjnV9o07PUZ_XxnNB/s1600/4.jpg" style='width:225.75pt;height:168.75pt;visibility:visible;mso-wrap-style:square' o:button="t"> <v:imagedata src="file:///C:\Users\LENOVO\AppData\Local\Temp\msohtmlclip1\01\clip_image006.jpg" o:title="4"/> </v:shape><![endif]--><!--[if !vml]--><span style="mso-ignore: vglayout;"></span><!--[endif]--></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;"><!--[if gte vml 1]><v:shape id="Picture_x0020_4" o:spid="_x0000_i1028" type="#_x0000_t75" alt="Description: https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBOHO5_2RDIBqJdXdqVLHDQcUqGj8z-TMjbgOTNym8-NLrM60gfS-bLeSBBpKU69x2IFJQ1liXDJe__ItwsL23mwe8-mg7AxL8OTdsFYrMQgwY3Wr5foRujw03OzqoqbbRS62fC6jS0DKs/s320/5.jpg" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjBOHO5_2RDIBqJdXdqVLHDQcUqGj8z-TMjbgOTNym8-NLrM60gfS-bLeSBBpKU69x2IFJQ1liXDJe__ItwsL23mwe8-mg7AxL8OTdsFYrMQgwY3Wr5foRujw03OzqoqbbRS62fC6jS0DKs/s1600/5.jpg" style='width:240pt;height:139.5pt;visibility:visible;mso-wrap-style:square' o:button="t"> <v:imagedata src="file:///C:\Users\LENOVO\AppData\Local\Temp\msohtmlclip1\01\clip_image007.jpg" o:title="5"/> </v:shape><![endif]--><!--[if !vml]--><span style="mso-ignore: vglayout;"></span><!--[endif]--></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;"><!--[if gte vml 1]><v:shape id="Picture_x0020_3" o:spid="_x0000_i1027" type="#_x0000_t75" alt="Description: https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh45NgBFkGIZhWNodME5f9ekngKG-rNDPVe3HTyjdJ3oi1mD7Rfd6OnQAfZRsHAzo2h67lUgRkSjU-G8JX9fn-eGwkjnl-eiKDgq9zZhQ60NruUcXhUggTrCNZRzwbfWsJBCx8DSztyd7Bb/s1600/6.jpg" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh45NgBFkGIZhWNodME5f9ekngKG-rNDPVe3HTyjdJ3oi1mD7Rfd6OnQAfZRsHAzo2h67lUgRkSjU-G8JX9fn-eGwkjnl-eiKDgq9zZhQ60NruUcXhUggTrCNZRzwbfWsJBCx8DSztyd7Bb/s1600/6.jpg" style='width:267pt;height:378.75pt;visibility:visible;mso-wrap-style:square' o:button="t"> <v:imagedata src="file:///C:\Users\LENOVO\AppData\Local\Temp\msohtmlclip1\01\clip_image008.jpg" o:title="6"/> </v:shape><![endif]--><!--[if !vml]--><span style="mso-ignore: vglayout;"></span><!--[endif]--></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;"><!--[if gte vml 1]><v:shape id="Picture_x0020_2" o:spid="_x0000_i1026" type="#_x0000_t75" alt="Description: https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirbKnSQ5nkg_5it_64kwQXy5SmKuqdL2IXbbmpe6uRUrNk8ByrZNxOxmUJuTl7bTEfMVoaM-UU5YUKMUoRf2KBaPDtj2-QG8dgj5IVay9Y6fXmGgWlsxg9n6vLH3qaefSAfyWPMgj8yIWG/s1600/7.jpg" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirbKnSQ5nkg_5it_64kwQXy5SmKuqdL2IXbbmpe6uRUrNk8ByrZNxOxmUJuTl7bTEfMVoaM-UU5YUKMUoRf2KBaPDtj2-QG8dgj5IVay9Y6fXmGgWlsxg9n6vLH3qaefSAfyWPMgj8yIWG/s1600/7.jpg" style='width:231.75pt;height:294pt;visibility:visible;mso-wrap-style:square' o:button="t"> <v:imagedata src="file:///C:\Users\LENOVO\AppData\Local\Temp\msohtmlclip1\01\clip_image009.jpg" o:title="7"/> </v:shape><![endif]--><!--[if !vml]--><span style="mso-ignore: vglayout;"></span><!--[endif]--></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;"><!--[if gte vml 1]><v:shape id="Picture_x0020_1" o:spid="_x0000_i1025" type="#_x0000_t75" alt="Description: https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2OfZNmo1yCYQOkd9YMNXi5RK53_sdrjH4M_iiOcNfmSjYFWH44ya0b9YvufOoWJF7vJ5_EkTY5xN3gyz9HtqS0G3fmu2YLZ35FoKMbcdQD0Xw4qzGpxTHGvqK0N0D1P_V2BqTHiaG4EkY/s1600/8.jpg" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2OfZNmo1yCYQOkd9YMNXi5RK53_sdrjH4M_iiOcNfmSjYFWH44ya0b9YvufOoWJF7vJ5_EkTY5xN3gyz9HtqS0G3fmu2YLZ35FoKMbcdQD0Xw4qzGpxTHGvqK0N0D1P_V2BqTHiaG4EkY/s1600/8.jpg" style='width:270.75pt;height:187.5pt;visibility:visible;mso-wrap-style:square' o:button="t"> <v:imagedata src="file:///C:\Users\LENOVO\AppData\Local\Temp\msohtmlclip1\01\clip_image010.jpg" o:title="8"/> </v:shape><![endif]--><!--[if !vml]--><span style="mso-ignore: vglayout;"></span><!--[endif]--></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...

Read more »

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

Read more »

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;" /> <!--[if !supportLineBreakNewLine]--><br style="mso-special-character: line-break;" /> <!--[endif]--></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;" /> <!--[if !supportLineBreakNewLine]--><br style="mso-special-character: line-break;" /> <!--[endif]--></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;"> <!--[if !supportLists]--><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><!--[endif]--><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;" /> <!--[if !supportLineBreakNewLine]--><br style="mso-special-character: line-break;" /> <!--[endif]--></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...

Read more »