Download Soal SMK

<p><h3 class="post-title entry-title" itemprop="name" style="font-stretch: normal; font-weight: normal; margin: 0.75em 0px 0px; position: relative; text-align: justify;">
<span style="font-family: inherit; font-size: small;"><b style="line-height: 1.4;">Visual Basic for Application</b><span style="background-color: white; line-height: 1.4;"> atau</span><span style="background-color: white; line-height: 1.4;"> </span><b style="line-height: 1.4;">VBA</b><span style="background-color: white; line-height: 1.4;"> </span><span style="background-color: white; line-height: 1.4;">adalah sebuah bahasa pemrograman yang dibuat oleh Microsoft dan dapat digunakan untuk meningkatkan kemampuan aplikasi Office, termasuk di dalamnya Excel.</span></span></h3>
<div class="post-body entry-content" id="post-body-1353783875229205104" itemprop="description articleBody" style="position: relative; width: 546px;">
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><span style="font-family: inherit;"><br /></span></span></div>
<b style="line-height: 1.4;"><div style="text-align: justify;">
<span style="font-family: inherit;"><b style="line-height: 1.4;">Macro</b><span style="line-height: 1.4;"> sendiri adalah kumpulan </span><i style="line-height: 1.4;">command</i><span style="line-height: 1.4;"> dan prosedur untuk melakukan tugas tertentu, disimpan dalam bentuk modul pada file Excel. Macro dapat dipanggil untuk menanggapi suatu kejadian (</span><i style="line-height: 1.4;">event</i><span style="line-height: 1.4;">) seperti suatu klik pada tombol.</span></span></div>
</b><div style="text-align: justify;">
<br /></div>
<span style="font-family: inherit; line-height: 1.4;"><div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">Dengan banyaknya masukan kepada kami untuk membuat artikel tutorial sederhana mengenai VBA dan Macro, kami coba jawab dengan artikel tutorial berikut dengan format ringkas, praktis, tapi padat.  Semoga artikel ini bisa bermanfaat untuk melangkah ke tahap belajar selanjutnya.</span></div>
</span><div style="text-align: justify;">
<br /></div>
</span><div>
<h3 style="line-height: 1.4; margin: 0px; position: relative; text-align: justify;">
<span style="background-color: white; font-family: inherit; font-size: small;">Praktek 1 : Mengaktifkan Tab Developer</span></h3>
<div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit;">Tab Developer berisi menu-menu yang akan kita gunakan untuk bekerja dengan VBA, berikut adalah langkah-langkah untuk mengaktifkan tab tersebut :</span></div>
<div>
<ol>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Jalankan aplikasi <b>Microsoft Excel 2007</b>.</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Klik menu</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Office</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: initial;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQ7muu1pIQsFDFAsgikdNVPu6hTfW6y5_PlJRMDkKpINMGoBccg2YumqLQjLx_H8zQUSiRZXAXU2g5fXw9VQ3JP8el0rtwi7K8_nxinhZAaUVak1Jir3v34-MsWSn_VUpvuh9oNg6yba0/s1600/office_button.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: initial;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQ7muu1pIQsFDFAsgikdNVPu6hTfW6y5_PlJRMDkKpINMGoBccg2YumqLQjLx_H8zQUSiRZXAXU2g5fXw9VQ3JP8el0rtwi7K8_nxinhZAaUVak1Jir3v34-MsWSn_VUpvuh9oNg6yba0/s1600/office_button.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: initial;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQ7muu1pIQsFDFAsgikdNVPu6hTfW6y5_PlJRMDkKpINMGoBccg2YumqLQjLx_H8zQUSiRZXAXU2g5fXw9VQ3JP8el0rtwi7K8_nxinhZAaUVak1Jir3v34-MsWSn_VUpvuh9oNg6yba0/s1600/office_button.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-radius: 0px; border: 1px solid transparent; box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; margin: 0px; padding: 0px; position: relative;" /></a></div>
</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Klik tombol </span><b style="font-family: inherit; line-height: 1.4;">Excel Options</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: initial;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQ2aJV-CSoRhysS3LoqZtDnQg4TIKsMZ1zIwuxp53n7vGxpGHvE7zBYwGOx6JFyO0C38zfe4Fc2mXnxmNoFs3_TJ6ufw5VcdCotaXglS-cFwpHTk8VrhpiSf103OVW1jJpwE1voKjIiI0/s1600/excel_options_button.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: initial;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQ2aJV-CSoRhysS3LoqZtDnQg4TIKsMZ1zIwuxp53n7vGxpGHvE7zBYwGOx6JFyO0C38zfe4Fc2mXnxmNoFs3_TJ6ufw5VcdCotaXglS-cFwpHTk8VrhpiSf103OVW1jJpwE1voKjIiI0/s1600/excel_options_button.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: initial;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQ2aJV-CSoRhysS3LoqZtDnQg4TIKsMZ1zIwuxp53n7vGxpGHvE7zBYwGOx6JFyO0C38zfe4Fc2mXnxmNoFs3_TJ6ufw5VcdCotaXglS-cFwpHTk8VrhpiSf103OVW1jJpwE1voKjIiI0/s1600/excel_options_button.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-radius: 0px; border: 1px solid transparent; box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; margin: 0px; padding: 0px; position: relative;" /></a></div>
</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Pada dialog yang muncul, pilih kategori <b>Popular</b> pada bagian panel kiri.</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Aktifkan opsi </span><b style="font-family: inherit; line-height: 1.4;">Show Developer tab in the Ribbon</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: initial;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiub7KyZ0J0Sin4lLYj41j3J0hscqTg7R8vGUey34QL8V6Y6LUi2iR9rsgWE0xhz1HxpJ9O8iLO7aMR9VvYy4vF-Qi1NmNMPrH5nZbvWoNCEby-iW9TAH951PX-2xvw4uI6hja-ONZl6EA/s1600/show_developer_tab_in_the_ribbon.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: initial;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiub7KyZ0J0Sin4lLYj41j3J0hscqTg7R8vGUey34QL8V6Y6LUi2iR9rsgWE0xhz1HxpJ9O8iLO7aMR9VvYy4vF-Qi1NmNMPrH5nZbvWoNCEby-iW9TAH951PX-2xvw4uI6hja-ONZl6EA/s1600/show_developer_tab_in_the_ribbon.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: initial;"><img border="0" height="158" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiub7KyZ0J0Sin4lLYj41j3J0hscqTg7R8vGUey34QL8V6Y6LUi2iR9rsgWE0xhz1HxpJ9O8iLO7aMR9VvYy4vF-Qi1NmNMPrH5nZbvWoNCEby-iW9TAH951PX-2xvw4uI6hja-ONZl6EA/s400/show_developer_tab_in_the_ribbon.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-radius: 0px; border: 1px solid transparent; box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; margin: 0px; padding: 0px; position: relative;" width="400" /></a></div>
</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Klik tombol <b>OK</b>.</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Pastikan tab </span><b style="font-family: inherit; line-height: 1.4;">Developer</b><span style="background-color: white; font-family: inherit; line-height: 1.4;"> sudah terlihat pada </span><b style="font-family: inherit; line-height: 1.4;">Ribbon</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: initial;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgH7QtKWE5hyphenhyphenzFepjao6bkQXUL6Zs57Xa1jvCcpnDPaMDaPQrSVoy0ir-6MEYscAlfjYnetPA6zbL3kSPiGh1lmDh2WzbOpLzYPB4Qc3yI4HMgW3xUwKQ9ieVTZvZCQVqC4nDVPc9bNZgE/s1600/tab_developer_active.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: initial;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgH7QtKWE5hyphenhyphenzFepjao6bkQXUL6Zs57Xa1jvCcpnDPaMDaPQrSVoy0ir-6MEYscAlfjYnetPA6zbL3kSPiGh1lmDh2WzbOpLzYPB4Qc3yI4HMgW3xUwKQ9ieVTZvZCQVqC4nDVPc9bNZgE/s1600/tab_developer_active.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: initial;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgH7QtKWE5hyphenhyphenzFepjao6bkQXUL6Zs57Xa1jvCcpnDPaMDaPQrSVoy0ir-6MEYscAlfjYnetPA6zbL3kSPiGh1lmDh2WzbOpLzYPB4Qc3yI4HMgW3xUwKQ9ieVTZvZCQVqC4nDVPc9bNZgE/s1600/tab_developer_active.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-radius: 0px; border: 1px solid transparent; box-shadow: rgba(0, 0, 0, 0.2) 0px 0px 0px; margin: 0px; padding: 0px; position: relative;" /></a></div>
</span></li>
</ol>
<div style="line-height: 1.4;">
<h3 style="margin: 0px; position: relative; text-align: justify;">
<span style="background-color: white; font-family: inherit; font-size: small;">Praktek 2 : Visual Basic Editor (Editor)</span></h3>
</div>
</div>
</div>
<div>
<ol>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Klik tab</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Developer</b><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">pada</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Ribbon</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">, dari group</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Code</b><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">klik</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Visual Basic</b><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">(atau tekan</span><b style="font-family: inherit; line-height: 1.4;">Alt+F11</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">).</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: none;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpjWR5mPgqy0qxXPtjrRR5uCGzmstByfUNDjH4TBhMVtg5m0tb4hN71N1v6_gZmfRdwnRU114oKbCmE3hMcuwcGe54HSf5g5CIOCQTVgRhvfnRzVQ6hI69TpdD3UV0LsLEbhiGp6YIZmo/s1600/visual_basic_editor_ribbon_developer.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: none;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpjWR5mPgqy0qxXPtjrRR5uCGzmstByfUNDjH4TBhMVtg5m0tb4hN71N1v6_gZmfRdwnRU114oKbCmE3hMcuwcGe54HSf5g5CIOCQTVgRhvfnRzVQ6hI69TpdD3UV0LsLEbhiGp6YIZmo/s1600/visual_basic_editor_ribbon_developer.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhpjWR5mPgqy0qxXPtjrRR5uCGzmstByfUNDjH4TBhMVtg5m0tb4hN71N1v6_gZmfRdwnRU114oKbCmE3hMcuwcGe54HSf5g5CIOCQTVgRhvfnRzVQ6hI69TpdD3UV0LsLEbhiGp6YIZmo/s1600/visual_basic_editor_ribbon_developer.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" /></a></div>
</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Akan muncul</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Visual Basic Editor</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">, yang merupakan tempat dimana kita memasukkan dan mencoba kode program kita.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: none;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIlYlI6oVhpnWwu-RZn5SUrN9-B2pA5uW-LrWvU2UJW4fkH1qJunzGoSaWRmIu4QC9WeD3yAsp-T54kpczIs3vyHLdZdW54K9oPuW994J7X4WEkQ0ddigVPGCxZVgKNG4XDZLFlx8QWEM/s1600/visual_basic_editor.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: none;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIlYlI6oVhpnWwu-RZn5SUrN9-B2pA5uW-LrWvU2UJW4fkH1qJunzGoSaWRmIu4QC9WeD3yAsp-T54kpczIs3vyHLdZdW54K9oPuW994J7X4WEkQ0ddigVPGCxZVgKNG4XDZLFlx8QWEM/s1600/visual_basic_editor.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="170" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIlYlI6oVhpnWwu-RZn5SUrN9-B2pA5uW-LrWvU2UJW4fkH1qJunzGoSaWRmIu4QC9WeD3yAsp-T54kpczIs3vyHLdZdW54K9oPuW994J7X4WEkQ0ddigVPGCxZVgKNG4XDZLFlx8QWEM/s320/visual_basic_editor.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" width="320" /></a></div>
</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Pada panel kiri atas - bagian project, klik kanan pada</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Sheet1</b><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">dari</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><i style="font-family: inherit; font-weight: bold; line-height: 1.4;">project</i><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">dengan nama </span><b style="font-family: inherit; line-height: 1.4;">VBAProject (Book1)</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">, kemudian pilih menu </span><b style="font-family: inherit; line-height: 1.4;">View Code</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">.</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: none;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5tI0id5f5GqrvTLQ5sTmW_fOR1Xgd2mxTbBI2_ORBe8S4hLoLjTtReROMSt0fFzoZnl_kbkCs3zxA7gcTt0hLf-hNLgg1hG9vzG3p2TvP2gCbulN98NudQxbB54lybPbOqrUo0-JllMQ/s1600/view_code.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5tI0id5f5GqrvTLQ5sTmW_fOR1Xgd2mxTbBI2_ORBe8S4hLoLjTtReROMSt0fFzoZnl_kbkCs3zxA7gcTt0hLf-hNLgg1hG9vzG3p2TvP2gCbulN98NudQxbB54lybPbOqrUo0-JllMQ/s1600/view_code.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" /></a></div>
<div style="text-align: justify;">
<br /></div>
<span style="font-family: inherit; line-height: 1.4;"><div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">Ini akan membuka tampilan editor untuk code kita, yang akan dikelompokkan dalam suatu </span><i style="font-family: inherit; line-height: 1.4;"><b>module</b></i><span style="font-family: inherit; line-height: 1.4;">. Ketikkan code berikut pada editor tersebut. </span></div>
</span><div style="text-align: justify;">
<br /></div>
</span><div class="MsoNormal" style="line-height: 1.4; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: white; font-family: inherit;"><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">Private</span> <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">Sub</span> APAKABAR<b>()</b></span></div>
<div class="MsoNormal" style="line-height: 1.4; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: white; font-family: inherit;">        Worksheets<b>(</b>"Sheet1"<b>).</b>Range<b>(</b>"A1"<b>).</b>Value <b>=</b> "APA KABAR"</span></div>
<div class="MsoNormal" style="line-height: 1.4; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: white; font-family: inherit;">        Worksheets<b>(</b>"Sheet1"<b>).</b>Range<b>(</b>"C3"<b>).</b>Value <b>=</b> "NAMAKU SYAMS ARDHI"</span></div>
<div class="MsoNormal" style="line-height: 1.4; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: white; font-family: inherit;"><span style="line-height: 15.3333320617676px;">End</span><span style="line-height: 15.3333320617676px;"> </span><span style="line-height: 15.3333320617676px;">Sub</span></span></div>
<div class="MsoNormal">
<div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<span style="background-color: white; font-family: inherit; line-height: 1.4;"><div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">Penjelasan : Code ini adalah perintah membuat satu procedure dengan nama APA KABAR, yang didefinisikan di dalam </span><span style="font-family: inherit; line-height: 1.4;">Private</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; line-height: 1.4;">Sub</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; line-height: 1.4;">...</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; line-height: 14px;">End</span><span style="font-family: inherit; line-height: 14px;"> </span><span style="font-family: inherit; line-height: 14px;">Sub</span><span style="font-family: inherit; line-height: 1.4;">.</span></div>
</span></div>
</li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Tekan tombol <b>F5</b> untuk menjalankan program . </span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Simpan file tersebut dengan klik Save As <b></b>. Pada Kotak Dialog Save As, ketikkan nama file misalnya dengan nama <b>BelajarVBA pada kotak File name. Lalu pastikan Anda memilih </b><i>Excel Macro-Enabled Workbook </i>pada kotak Save as type. Perhatikan, ekstensi yang disimpan bukan tipe <b>xlsx</b>. tetapi file <b>.xlsm</b>. </span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Selanjutnya, Anda akan menemukan pada</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Sheet1</b><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">terisi kata "</span><b style="font-family: inherit; line-height: 1.4;">APA KABAR</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">" pada</span><b style="font-family: inherit; line-height: 1.4;">selA1</b><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">dan</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">C3</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: none;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6tiPMysu1-el48ISzoh4_XajrNlsZ-tD-cgQZsD9mekSThgpnsBX0wtZ9l_jcWNkoiEt0n62NPyBx935LcBeQ7RNv_JhxygBhx2RyakaF3sn0J-HwY5XAF6BW4gV4qULA0nKZOdolv-M/s1600/hello_world_a1_c3.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: none;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6tiPMysu1-el48ISzoh4_XajrNlsZ-tD-cgQZsD9mekSThgpnsBX0wtZ9l_jcWNkoiEt0n62NPyBx935LcBeQ7RNv_JhxygBhx2RyakaF3sn0J-HwY5XAF6BW4gV4qULA0nKZOdolv-M/s1600/hello_world_a1_c3.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6tiPMysu1-el48ISzoh4_XajrNlsZ-tD-cgQZsD9mekSThgpnsBX0wtZ9l_jcWNkoiEt0n62NPyBx935LcBeQ7RNv_JhxygBhx2RyakaF3sn0J-HwY5XAF6BW4gV4qULA0nKZOdolv-M/s1600/hello_world_a1_c3.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" /></a></div>
</span></li>
</ol>
<div>
<h3 style="line-height: 1.4; margin: 0px; position: relative; text-align: justify;">
<span style="background-color: white; font-family: inherit; font-size: small;">Praktek 3 : Menambahkan Visual Control</span></h3>
<div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit;"><b>Control</b> adalah komponen visual / grafis seperti tombol, yang dapat ditempatkan pada worksheet kita sehingga aplikasi kita menjadi lebih interaktif. Berikut adalah contoh penggunaan control : </span></div>
<div>
<ol>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Masih pada <b>Sheet1</b>, coba arahkan cursor ke alamat <b>E1</b>.</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Pada tab</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Developer</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">, group</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Controls</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">, klik gambar panah bawah kecil pada menu </span><b style="font-family: inherit; line-height: 1.4;">Insert</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">. Dari pilihan yang muncul klik</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Spin Button (Form Control)</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">, gambar bentuknya pada sheet kita.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<span style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; font-family: inherit; line-height: 1.4;"><div style="text-align: justify;">
<img src="http://static.phi-integration.com/animated-insert-control.gif" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; font-family: inherit; line-height: 1.4; padding: 5px;" /></div>
</span></span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Klik kanan pada spinner tersebut, dan pilih <b>Format Control</b>.</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Pada dialog yang muncul, klik tab Control dan masukkan nilai-nilai berikut, dan klik tombol OK setelah selesai.</span></li>
<ul style="line-height: 1.4; margin: 0.5em 0px; padding: 0px 2.5em;">
<li style="margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Current Value : <b>0</b>.</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Minimum Value : <b>0</b>.</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Maximum Value : <b>200</b>.</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Incremental Change : <b>25</b>.</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Cell link : <b>A2</b>.</span></li>
</ul>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Cobalah klik gambar panah pada spinner dan perhatikan perubahan nilai yang terjadi pada cell <b>A2</b>.</span></li>
</ol>
</div>
</div>
</div>
<h3 style="line-height: 1.4; margin: 0px; position: relative; text-align: justify;">
<span style="background-color: white; font-family: inherit; font-size: small;">Praktek 4 : Menambahkan Macro sebagai <i>Event Handling</i> pada Control</span></h3>
<ol>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Klik kanan pada <i>spinner control</i> tersebut, pilih <b>Assign Macro</b>. </span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Pada dialog yang muncul klik tombol <b><u>N</u>ew</b>.</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Editor VBE akan muncul kembali dengan cursor berada pada prosedur bernama</span><span style="background-color: white; font-family: inherit; line-height: 1.4;">Spinner[INDEX]_Change()</span><span style="background-color: white; font-family: inherit; line-height: 1.4;">. Tambahkan code berikut pada</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><i style="font-family: inherit; line-height: 1.4;">body </i><span style="background-color: white; font-family: inherit; line-height: 1.4;">prosedur.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
</span><div class="MsoNormal" style="line-height: 1.4;">
</div>
<div class="MsoNormal" style="line-height: 1.4; margin-right: -0.75in;">
</div>
<div class="MsoNormal" style="line-height: 1.4; margin-bottom: 0.0001pt; text-align: justify;">
<span style="background-color: white; font-family: inherit;"><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">Dim</span> NilaiSpinner <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">As</span> <span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">Integer</span></span></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<span style="background-color: white; font-family: inherit; line-height: 1.4;"><div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">NilaiSpinner</span><span style="font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">=</b><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; line-height: 1.4;">ThisWorkbook.Sheets</span><b style="font-family: inherit; line-height: 1.4;">(</b><b style="font-family: inherit; line-height: 1.4;"><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">1</span></b><b style="font-family: inherit; line-height: 1.4;">).</b><span style="font-family: inherit; line-height: 1.4;">Spinners</span><b style="font-family: inherit; line-height: 1.4;">(</b><b style="font-family: inherit; line-height: 1.4;"><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial;">1</span></b><b style="font-family: inherit; line-height: 1.4;">).</b><span style="font-family: inherit; line-height: 1.4;">Value</span></div>
</span></div>
<div class="MsoNormal" style="margin-right: -0.75in;">
<div style="text-align: justify;">
<span style="line-height: 15.3333320617676px;"><br /></span></div>
<span style="background-color: white; font-family: inherit; line-height: 1.4;"><div style="text-align: justify;">
<span style="font-family: inherit; line-height: 15.3333320617676px;">ThisWorkbook.Sheets<b>(</b></span><b style="font-family: inherit; line-height: 1.4;"><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; line-height: 15.3333320617676px;">1</span></b><b style="font-family: inherit; line-height: 1.4;"><span style="line-height: 15.3333320617676px;">).</span></b><span style="font-family: inherit; line-height: 15.3333320617676px;">Spinners<b>(</b></span><b style="font-family: inherit; line-height: 1.4;"><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; line-height: 15.3333320617676px;">1</span></b><b style="font-family: inherit; line-height: 1.4;"><span style="line-height: 15.3333320617676px;">).</span></b><span style="font-family: inherit; line-height: 15.3333320617676px;">Top <b>=</b> NilaiSpinner</span></div>
</span></div>
<span style="background-color: white;"><div style="line-height: 22.3999996185303px; text-align: justify;">
<br /></div>
</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Simpan dengan menekan <b>CTRL + S</b>.</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Kembali ke worksheet dan coba klik <i>spinner</i> kita, akan terlihat spinner kita bergerak ke atas atau ke bawah sesuai irama klik tombol panah atas bawah pada spinner.</span></li>
</ol>
<h3 style="line-height: 1.4; margin: 0px; position: relative; text-align: justify;">
<span style="background-color: white; font-family: inherit; font-size: small;">Praktek 5 : Menyimpan dan Membuka Kembali Workbook VBA kita</span></h3>
<div>
<ol>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Tutup dan kemudian buka kembali <i>workbook</i> kita.</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Secara</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><i style="font-family: inherit; line-height: 1.4;">default</i><span style="background-color: white; font-family: inherit; line-height: 1.4;">, Excel 2007 akan menonaktifkan perintah VBA / Macro pada workbook yang kita buka. Terlihat pada security warning yang muncul pada bar bagian atas</span><i style="font-family: inherit; line-height: 1.4;">worksheet</i><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">(gambar).</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: none;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggYY0JibPZpR7QuMoCKajPyk5P_T7FLnIXeAjq7jafQWWmbHFTz0QrlNy_EJyy05PrYkY0leMoC_UhA96IzyFkJZgZV6ukwNDe01VABUfx8oBHC6bPmTJLQISWm8Zfquiq8Nogmg9xhWM/s1600/security_warning_macro.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: none;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggYY0JibPZpR7QuMoCKajPyk5P_T7FLnIXeAjq7jafQWWmbHFTz0QrlNy_EJyy05PrYkY0leMoC_UhA96IzyFkJZgZV6ukwNDe01VABUfx8oBHC6bPmTJLQISWm8Zfquiq8Nogmg9xhWM/s1600/security_warning_macro.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggYY0JibPZpR7QuMoCKajPyk5P_T7FLnIXeAjq7jafQWWmbHFTz0QrlNy_EJyy05PrYkY0leMoC_UhA96IzyFkJZgZV6ukwNDe01VABUfx8oBHC6bPmTJLQISWm8Zfquiq8Nogmg9xhWM/s1600/security_warning_macro.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" /></a></div>
</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Klik tombol <b>Options</b> pada bar tersebut.</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Pilih opsi <b>Enable this content</b>, klik tombol <b>OK</b>.</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Anda sudah dapat menjalankan kembali code VBA Anda.</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Selesai.</span></li>
</ol>
<h3 style="line-height: 1.4; margin: 0px; position: relative; text-align: justify;">
<span style="background-color: white; font-family: inherit; font-size: small;">Kesimpulan</span></h3>
</div>
<span style="background-color: white;"><div style="font-family: inherit; line-height: 1.4; text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">Demikian kami tuangkan cara penggunaan dasar VBA dengan</span><span style="font-family: inherit; line-height: 1.4;"> </span><i style="font-family: inherit; line-height: 1.4;">break down</i><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; line-height: 1.4;">praktek 1 sampai dengan 5. Semoga ini dapat memberikan sedikit pengalaman dan pencerahan bagi Anda untuk melanjutkan pembelajaran melalui berbagai artikel VBA yang ada di internet dan media lainnya.</span></div>
<div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="text-align: justify;">
<br /></div>
</span><h2 class="post-title entry-title" style="line-height: 1.4; margin: 0px; position: relative; text-align: justify;">
<a href="http://www.belajarexcel.info/2013/09/mengaktifkan-developer-tab-di-excel-2010.html" style="text-decoration: none;"><span style="background-color: white; color: black; font-family: inherit; font-size: small;">Mengaktifkan Tab Developer pada Excel 2010</span></a></h2>
<h2 class="post-title entry-title" style="margin: 0px; position: relative;">
<div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; font-size: small; line-height: 1.4;"> Pada tutorial VBA dasar, penulis menunjukkan bagaimana developer tab diaktifkan di MS Excel 2007. Nah, ternyata terdapat perbedaanuntuk mengaktifkan tab yang sama di MS Excel 2010.</span></div>
<span style="background-color: white; font-size: small;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<span style="font-family: inherit; line-height: 1.4;"><div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">Berikut adalah langkah-langkah untuk mengaktifkan tab developer di MS Excel 2010:</span></div>
</span><div style="text-align: justify;">
<br /></div>
</span></h2>
<ol>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Pilih menu tab</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">File </b><span style="background-color: white; font-family: inherit; line-height: 1.4;">|</span><b style="font-family: inherit; line-height: 1.4;"> Options</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: none;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgOIDUlyeJwXrpN0MvrLsdk6ALI_4h0o-fAm4cljhUY2cdbYzW1z6Mwspqj4V0QCf2djBhyZP61-iq9kizxnQvl4mYCXNpbTvX5kJMVeUtFI7yFft7PxmBckMBe5CkhF-t7sC6E5pnR7Q/s1600/menu_file_options_excel_2010_compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: none;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgOIDUlyeJwXrpN0MvrLsdk6ALI_4h0o-fAm4cljhUY2cdbYzW1z6Mwspqj4V0QCf2djBhyZP61-iq9kizxnQvl4mYCXNpbTvX5kJMVeUtFI7yFft7PxmBckMBe5CkhF-t7sC6E5pnR7Q/s1600/menu_file_options_excel_2010_compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgOIDUlyeJwXrpN0MvrLsdk6ALI_4h0o-fAm4cljhUY2cdbYzW1z6Mwspqj4V0QCf2djBhyZP61-iq9kizxnQvl4mYCXNpbTvX5kJMVeUtFI7yFft7PxmBckMBe5CkhF-t7sC6E5pnR7Q/s1600/menu_file_options_excel_2010_compressed.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" /></a></div>
</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Pada dialog</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Excel Options</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">, pilih</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Customize Ribbon</b><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">pada bagian panel kiri.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: none;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhn8f3crlhZKMSuUI6oU3706WP1FpOd2lsKUuIItUfeNnFZaNiENCf5S3GcB3PaVAZxaoAlncVNyCvSuMjfogwYiYUcTGQQwhlMdFFd3OhNGwLedzcK0B7E9BrU2HC0mokPEpBsnWEU1os/s1600/excel_options_customize_ribbon_compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: none;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhn8f3crlhZKMSuUI6oU3706WP1FpOd2lsKUuIItUfeNnFZaNiENCf5S3GcB3PaVAZxaoAlncVNyCvSuMjfogwYiYUcTGQQwhlMdFFd3OhNGwLedzcK0B7E9BrU2HC0mokPEpBsnWEU1os/s1600/excel_options_customize_ribbon_compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhn8f3crlhZKMSuUI6oU3706WP1FpOd2lsKUuIItUfeNnFZaNiENCf5S3GcB3PaVAZxaoAlncVNyCvSuMjfogwYiYUcTGQQwhlMdFFd3OhNGwLedzcK0B7E9BrU2HC0mokPEpBsnWEU1os/s1600/excel_options_customize_ribbon_compressed.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" /></a></div>
</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Pada bagian <b>Choose commands from:</b>, pilih <b>Main Tabs</b>.</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Pilih</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Developer</b><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">dan klik tombol "</span><b style="font-family: inherit; line-height: 1.4;">Add >></b><span style="background-color: white; font-family: inherit; line-height: 1.4;">".</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: none;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgq80G7bEjP7IVGRFVusaHyq4FCsF4zoWHU-TDhMD9VAmj41W_U_0TwRVvCLyOP9OymhyG9VMF6SAIyFPIJLJcFOwpLik0AD1FQc3PjljXfrqM7yc3bXPp-yQQy2ZLUQADcD4i-Bde_seQ/s1600/choose_command_developer_compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: none;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgq80G7bEjP7IVGRFVusaHyq4FCsF4zoWHU-TDhMD9VAmj41W_U_0TwRVvCLyOP9OymhyG9VMF6SAIyFPIJLJcFOwpLik0AD1FQc3PjljXfrqM7yc3bXPp-yQQy2ZLUQADcD4i-Bde_seQ/s1600/choose_command_developer_compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="260" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgq80G7bEjP7IVGRFVusaHyq4FCsF4zoWHU-TDhMD9VAmj41W_U_0TwRVvCLyOP9OymhyG9VMF6SAIyFPIJLJcFOwpLik0AD1FQc3PjljXfrqM7yc3bXPp-yQQy2ZLUQADcD4i-Bde_seQ/s400/choose_command_developer_compressed.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" width="400" /></a></div>
</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Klik tombol <b>OK</b>.</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Tab</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Developer</b><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">sudah aktif dan siap digunakan.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: none;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMQ8n97KffSO3ceDOf1zmEGD9yXrK2aHVW2S89K3leVDVsY8jDiT-bj8Tgix027gR5CtMWGVlZKARCTcQki-IMTuttOUDUs2mv9c5xUVGHb0f6IxwZjgPDn2kACKku02MscvBCYBujEq0/s1600/developer_tab_compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: none;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMQ8n97KffSO3ceDOf1zmEGD9yXrK2aHVW2S89K3leVDVsY8jDiT-bj8Tgix027gR5CtMWGVlZKARCTcQki-IMTuttOUDUs2mv9c5xUVGHb0f6IxwZjgPDn2kACKku02MscvBCYBujEq0/s1600/developer_tab_compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMQ8n97KffSO3ceDOf1zmEGD9yXrK2aHVW2S89K3leVDVsY8jDiT-bj8Tgix027gR5CtMWGVlZKARCTcQki-IMTuttOUDUs2mv9c5xUVGHb0f6IxwZjgPDn2kACKku02MscvBCYBujEq0/s1600/developer_tab_compressed.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" /></a></div>
</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Selesai.</span></li>
</ol>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
</span><h2 class="post-title entry-title" style="line-height: 1.4; margin: 0px; position: relative; text-align: justify;">
<a href="http://www.belajarexcel.info/2013/12/vba-menggunakan-form-pada-excel-2010.html" style="text-decoration: none;"><span style="background-color: white; color: black; font-family: inherit; font-size: small;">VBA: Menggunakan Form pada Excel 2007 - 2010 - 2013</span></a></h2>
<h2 class="post-title entry-title" style="margin: 0px; position: relative;">
<div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; font-size: small; line-height: 1.4;">Ada cukup banyak jenis</span><span style="background-color: white; font-family: inherit; font-size: small; line-height: 1.4;"> </span><i style="font-family: inherit; font-size: medium; line-height: 1.4;">form</i><span style="background-color: white; font-family: inherit; font-size: small; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; font-size: small; line-height: 1.4;">yang dapat digunakan bersama VBA di Excel, tapi jika yang dimaksud adalah</span><span style="background-color: white; font-family: inherit; font-size: small; line-height: 1.4;"> </span><i style="font-family: inherit; font-size: medium; line-height: 1.4;">form</i><span style="background-color: white; font-family: inherit; font-size: small; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; font-size: small; line-height: 1.4;">yang dapat kita buat dengan fleksibel maka itu adalah</span><span style="background-color: white; font-family: inherit; font-size: small; line-height: 1.4;"> </span><a href="http://office.microsoft.com/en-001/excel-help/overview-of-forms-form-controls-and-activex-controls-on-a-worksheet-HA010237663.aspx?CTT=1#BMvba_userforms" style="font-family: inherit; font-size: medium; line-height: 1.4; text-decoration: none;" target="_blank">UserForm</a><span style="background-color: white; font-family: inherit; font-size: small; line-height: 1.4;">.</span></div>
<span style="background-color: white; font-size: small;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<span style="font-family: inherit; line-height: 1.4;"><div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">Artikel berikut akan menunjukkan cara membuat userForm, menambahkan kontrol di atasnya dan memasukkan kode VBA sehingga dapat berinteraksi dengan worksheet Excel 2010.</span></div>
</span></span></h2>
<h3 style="line-height: 1.4; margin: 0px; position: relative; text-align: justify;">
<span style="background-color: white; font-family: inherit; font-size: small;">Menambahkan dan Menyusun Layout Form</span></h3>
<ol>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Jalankan aplikasi Microsoft Excel 2010.</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Buat dan simpan <i>worksheet</i> baru dengan nama <b>userform-excel-2010.xlsm</b>.</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Tekan CTRL+F11 untuk membuka <b>Visual Basic Editor</b>. Jika penekanan tombol tersebut tidak berhasil, klik tab menu <b>Developer</b> dan pilih <b>Visual Basic</b>.</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Pada bagian jendela </span><b style="font-family: inherit; line-height: 1.4;">Project Explorer</b><span style="background-color: white; font-family: inherit; line-height: 1.4;"> klik kanan pada node</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">VBA Project</b><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">dan pilih menu </span><b style="font-family: inherit; line-height: 1.4;">Insert</b><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">diikuti</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">UserForm</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: none;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsgqmbTpDxBPgvH-sWOAey0Yj23Itmg5f4UQSxYGNeYjVpKbJNMPTjcczguIQ-rHF79e3TFUPM3_E5oUr8EgwUiQqv2AOibPkBHg5MmkrZDiZlzjDwwUgAmyPLANs1e1ltrm5ebepipMk/s1600/add-user-form-excel-2010-compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: none;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsgqmbTpDxBPgvH-sWOAey0Yj23Itmg5f4UQSxYGNeYjVpKbJNMPTjcczguIQ-rHF79e3TFUPM3_E5oUr8EgwUiQqv2AOibPkBHg5MmkrZDiZlzjDwwUgAmyPLANs1e1ltrm5ebepipMk/s1600/add-user-form-excel-2010-compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsgqmbTpDxBPgvH-sWOAey0Yj23Itmg5f4UQSxYGNeYjVpKbJNMPTjcczguIQ-rHF79e3TFUPM3_E5oUr8EgwUiQqv2AOibPkBHg5MmkrZDiZlzjDwwUgAmyPLANs1e1ltrm5ebepipMk/s1600/add-user-form-excel-2010-compressed.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" /></a></div>
</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Akan muncul satu form dengan nama</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">UserForm1</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">. Muncul juga satu dialog</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Toolbox</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">dimana kita bisa mengambil berbagai kontrol untuk diletakkan pada form, dan terakhir ada panel</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Properties</b><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">yang bisa gunakan untuk melakukan konfigurasi form maupun kontrol.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: none;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhv8t8i5McEKmlbJKPgkiaL61oItTCQA67w48NFbZfgm1WTMzLs1punVnUgID-BUaxWsMmkOdE2C8QZTSrdPn9jzD5czOzOOLZdWtPkXlUQa8eiRWywDQrN_hLJF6mNhHVt71GCuMwIo_I/s1600/VBE+-+blank+form+-+compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: none;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhv8t8i5McEKmlbJKPgkiaL61oItTCQA67w48NFbZfgm1WTMzLs1punVnUgID-BUaxWsMmkOdE2C8QZTSrdPn9jzD5czOzOOLZdWtPkXlUQa8eiRWywDQrN_hLJF6mNhHVt71GCuMwIo_I/s1600/VBE+-+blank+form+-+compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="313" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhv8t8i5McEKmlbJKPgkiaL61oItTCQA67w48NFbZfgm1WTMzLs1punVnUgID-BUaxWsMmkOdE2C8QZTSrdPn9jzD5czOzOOLZdWtPkXlUQa8eiRWywDQrN_hLJF6mNhHVt71GCuMwIo_I/s1600/VBE+-+blank+form+-+compressed.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" width="400" /></a></div>
</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Pada Properties, rubah nama dari UserForm1 menjadi <b>FormEntri</b>. Pada caption, rubah teks UserForm1 menjadi <b>Form Entri</b>.</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Pada Toolbox, klik kontrol</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Label</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: none;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtqe64-Zx3FMKCA2xXnjoMDmivYvhua-cct9sGCIqmXH-tpduCsDijGMNHk2JoLHLwkT7Jo1P4lXKBffqmudPLfoHQ1QvTxkOO-7I8jTUZChlYFPMg4EihK15IIJLth-yVNiQxTUymWJ4/s1600/add_label_control-compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: none;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtqe64-Zx3FMKCA2xXnjoMDmivYvhua-cct9sGCIqmXH-tpduCsDijGMNHk2JoLHLwkT7Jo1P4lXKBffqmudPLfoHQ1QvTxkOO-7I8jTUZChlYFPMg4EihK15IIJLth-yVNiQxTUymWJ4/s1600/add_label_control-compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtqe64-Zx3FMKCA2xXnjoMDmivYvhua-cct9sGCIqmXH-tpduCsDijGMNHk2JoLHLwkT7Jo1P4lXKBffqmudPLfoHQ1QvTxkOO-7I8jTUZChlYFPMg4EihK15IIJLth-yVNiQxTUymWJ4/s1600/add_label_control-compressed.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" /></a></div>
</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Klik salah satu area pada form Anda dan atur penempatan label yang akan segera ditambahkan ke form tersebut. Hasilnya kira-kira terlihat terlihat seperti pada gambar berikut.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: none;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNagRz_QFdfhmjcDkwiXo4Xtnnz8Au87UAVNZglKA7aG1Y7h7R2PDRYsbtfkl5kN7OhyY2aBtsskS7mOKSFXcDna6DQWwIChSLmaoZc2mvqwWoQmNq4jRpeCs-a-alMPgy3bhnfeK8SNQ/s1600/kontrol-label-1-compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: none;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNagRz_QFdfhmjcDkwiXo4Xtnnz8Au87UAVNZglKA7aG1Y7h7R2PDRYsbtfkl5kN7OhyY2aBtsskS7mOKSFXcDna6DQWwIChSLmaoZc2mvqwWoQmNq4jRpeCs-a-alMPgy3bhnfeK8SNQ/s1600/kontrol-label-1-compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="224" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNagRz_QFdfhmjcDkwiXo4Xtnnz8Au87UAVNZglKA7aG1Y7h7R2PDRYsbtfkl5kN7OhyY2aBtsskS7mOKSFXcDna6DQWwIChSLmaoZc2mvqwWoQmNq4jRpeCs-a-alMPgy3bhnfeK8SNQ/s1600/kontrol-label-1-compressed.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" width="320" /></a></div>
</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Pada Properties, namakan label tersebut dengan mengisi teks pada bagian Name dengan <b>lblNama</b> dan pada Caption isi dengan teks <b>Nama</b>.</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Klik area pada</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><i style="font-family: inherit; line-height: 1.4;">form</i><span style="background-color: white; font-family: inherit; line-height: 1.4;"> untuk memunculkan kembali Toolbox. Tambahkan kontrol</span><b style="font-family: inherit; line-height: 1.4;">Textbox</b><span style="background-color: white; font-family: inherit; line-height: 1.4;"> pada form dengan cara seperti pada langkah 7 dan 8.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: none;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7mSboZ1Dj9GkC7oAJy-vYtFv4vDEG8UaEk3EYDAbbGlhfKogqwudVNhutS-0US6s0XVz5VEfU8QVeppvJ4031MsNsRdpQhQYxlexv19lMKyuAkeOLrJzWjsR_i2ZB12h8kQNPybD3cjw/s1600/add-textbox-control-compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: none;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7mSboZ1Dj9GkC7oAJy-vYtFv4vDEG8UaEk3EYDAbbGlhfKogqwudVNhutS-0US6s0XVz5VEfU8QVeppvJ4031MsNsRdpQhQYxlexv19lMKyuAkeOLrJzWjsR_i2ZB12h8kQNPybD3cjw/s1600/add-textbox-control-compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7mSboZ1Dj9GkC7oAJy-vYtFv4vDEG8UaEk3EYDAbbGlhfKogqwudVNhutS-0US6s0XVz5VEfU8QVeppvJ4031MsNsRdpQhQYxlexv19lMKyuAkeOLrJzWjsR_i2ZB12h8kQNPybD3cjw/s1600/add-textbox-control-compressed.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" /></a></div>
</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Pada Properties, namakan textbox tersebut dengan mengisi <b>txtNama</b> pada bagian Name.</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Klik area pada <i>form</i> untuk memunculkan kembali Toolbox.</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Tambahkan dua kontrol command button pada form. Isi Name untuk masing-masing tersebut dengan <b>btnHapus</b> dan <b>btnTambah</b>. Caption untuk btnHapus diisi dengan teks <b>Hapus</b>, dan untuk btnTambah dengan teks <b>Tambah</b>.</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Tampilan form akhir Anda akan terlihat seperti pada gambar</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><i style="font-family: inherit; line-height: 1.4;">screenshot</i><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">berikut ini.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: none;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5psAiEKklbnAq_KqV0UNFzxRGzlCwUwwqefPkNVGQlDWSr649RQpvZAzRYbXLt93gKlsaM6sqG5kABl5vDyCD4zEAPa5nao3vPjZtVAZ1kPMlTcc8plFjiqnKaD4MQDTA6dJWBfHjVXE/s1600/form-final-design-compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: none;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5psAiEKklbnAq_KqV0UNFzxRGzlCwUwwqefPkNVGQlDWSr649RQpvZAzRYbXLt93gKlsaM6sqG5kABl5vDyCD4zEAPa5nao3vPjZtVAZ1kPMlTcc8plFjiqnKaD4MQDTA6dJWBfHjVXE/s1600/form-final-design-compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5psAiEKklbnAq_KqV0UNFzxRGzlCwUwwqefPkNVGQlDWSr649RQpvZAzRYbXLt93gKlsaM6sqG5kABl5vDyCD4zEAPa5nao3vPjZtVAZ1kPMlTcc8plFjiqnKaD4MQDTA6dJWBfHjVXE/s1600/form-final-design-compressed.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" /></a></div>
</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Simpan worksheet Anda dengan menekan tombol CTRL+S.</span></li>
</ol>
<div style="line-height: 1.4;">
<h3 style="margin: 0px; position: relative; text-align: justify;">
<span style="background-color: white; font-family: inherit; font-size: small;">Menambahkan Kode VBA</span></h3>
</div>
<div>
<ol>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Klik dua kali pada tombol dengan caption Tambah sehingga memunculkan editor dengan teks berikut.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: none;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUdMaztgig3yVa6nxw58eSxcDHVaxLWZ-y2Ti8lDmkRjSHiiAVSYEDEcUNvD4zuzNqA2t_aSQTmev2Yn4WTFvP48YrnhvliCfdx-R9vafc8f3s3E2cCdKQrPKu2wtvH2kuv19wkZm-m18/s1600/btnTambah_Click-compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: none;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUdMaztgig3yVa6nxw58eSxcDHVaxLWZ-y2Ti8lDmkRjSHiiAVSYEDEcUNvD4zuzNqA2t_aSQTmev2Yn4WTFvP48YrnhvliCfdx-R9vafc8f3s3E2cCdKQrPKu2wtvH2kuv19wkZm-m18/s1600/btnTambah_Click-compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUdMaztgig3yVa6nxw58eSxcDHVaxLWZ-y2Ti8lDmkRjSHiiAVSYEDEcUNvD4zuzNqA2t_aSQTmev2Yn4WTFvP48YrnhvliCfdx-R9vafc8f3s3E2cCdKQrPKu2wtvH2kuv19wkZm-m18/s1600/btnTambah_Click-compressed.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" /></a></div>
</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Tambahkan kode berikut ke dalam fungsi</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">btnTambah_Click()</span><span style="background-color: white; font-family: inherit; line-height: 1.4;">.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<span style="font-family: inherit; line-height: 1.4; white-space: pre;"><div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">    </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">Dim</span><span style="font-family: inherit; line-height: 1.4;"> rangeSheet1 </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">As</span><span style="font-family: inherit; line-height: 1.4;"> Range</span></div>
</span><span style="font-family: inherit; line-height: 1.4; white-space: pre;">    
<div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">    </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">For</span><span style="font-family: inherit; line-height: 1.4;"> i </span><span style="font-family: inherit; line-height: 1.4;">=</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; line-height: 1.4;">1</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">To</span><span style="font-family: inherit; line-height: 1.4;"> Sheet1</span><span style="font-family: inherit; line-height: 1.4;">.</span><span style="font-family: inherit; line-height: 1.4;">Rows</span><span style="font-family: inherit; line-height: 1.4;">.</span><span style="font-family: inherit; line-height: 1.4;">Count</span></div>
</span><span style="font-family: inherit; line-height: 1.4; white-space: pre;"><div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">        </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">Set</span><span style="font-family: inherit; line-height: 1.4;"> rangeSheet1 </span><span style="font-family: inherit; line-height: 1.4;">=</span><span style="font-family: inherit; line-height: 1.4;"> Range</span><span style="font-family: inherit; line-height: 1.4;">(</span><span style="font-family: inherit; line-height: 1.4;">"A"</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; line-height: 1.4;">&</span><span style="font-family: inherit; line-height: 1.4;"> i</span><span style="font-family: inherit; line-height: 1.4;">)</span></div>
</span><span style="font-family: inherit; line-height: 1.4; white-space: pre;"><div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">        </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">If</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">Len</span><span style="font-family: inherit; line-height: 1.4;">(</span><span style="font-family: inherit; line-height: 1.4;">rangeSheet1</span><span style="font-family: inherit; line-height: 1.4;">.</span><span style="font-family: inherit; line-height: 1.4;">Value</span><span style="font-family: inherit; line-height: 1.4;">)</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; line-height: 1.4;">=</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; line-height: 1.4;">0</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">Then</span></div>
</span><span style="font-family: inherit; line-height: 1.4; white-space: pre;"><div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">            rangeSheet1</span><span style="font-family: inherit; line-height: 1.4;">.</span><span style="font-family: inherit; line-height: 1.4;">Value </span><span style="font-family: inherit; line-height: 1.4;">=</span><span style="font-family: inherit; line-height: 1.4;"> txtNama</span><span style="font-family: inherit; line-height: 1.4;">.</span><span style="font-family: inherit; line-height: 1.4;">Text</span></div>
</span><span style="font-family: inherit; line-height: 1.4; white-space: pre;"><div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">            </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">Exit</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">For</span></div>
</span><span style="font-family: inherit; line-height: 1.4; white-space: pre;"><div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">        </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">End</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">If</span></div>
</span><span style="font-family: inherit; line-height: 1.4; white-space: pre;"><div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">    </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">Next</span><span style="font-family: inherit; line-height: 1.4;"> i</span></div>
</span></span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Klik dua kali pada tombol dengan caption Hapus dan tambahkan kode berikut ke dalam  fungsi</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">btnHapus_Click()</span><span style="background-color: white; font-family: inherit; line-height: 1.4;">.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
</span><pre style="line-height: 1.4;"><div style="text-align: justify;">
<span style="font-family: inherit; font-weight: bold; line-height: 1.4;">    Dim</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> rangeSheet1 </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">As</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> Range</span></div>
<span style="background-color: white; font-family: inherit;">    
<div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">    btnTambah.Enabled = False</span></div>
<div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">    </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">For</span><span style="font-family: inherit; line-height: 1.4;"> i </span><span style="font-family: inherit; line-height: 1.4;">=</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; line-height: 1.4;">1</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">To</span><span style="font-family: inherit; line-height: 1.4;"> Sheet1</span><span style="font-family: inherit; line-height: 1.4;">.</span><span style="font-family: inherit; line-height: 1.4;">Rows</span><span style="font-family: inherit; line-height: 1.4;">.</span><span style="font-family: inherit; line-height: 1.4;">Count</span></div>
<div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">        </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">Set</span><span style="font-family: inherit; line-height: 1.4;"> rangeSheet1 </span><span style="font-family: inherit; line-height: 1.4;">=</span><span style="font-family: inherit; line-height: 1.4;"> Range</span><span style="font-family: inherit; line-height: 1.4;">(</span><span style="font-family: inherit; line-height: 1.4;">"A"</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; line-height: 1.4;">&</span><span style="font-family: inherit; line-height: 1.4;"> i</span><span style="font-family: inherit; line-height: 1.4;">)</span></div>
<div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">        </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">If</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">Len</span><span style="font-family: inherit; line-height: 1.4;">(</span><span style="font-family: inherit; line-height: 1.4;">rangeSheet1</span><span style="font-family: inherit; line-height: 1.4;">.</span><span style="font-family: inherit; line-height: 1.4;">Value</span><span style="font-family: inherit; line-height: 1.4;">)</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; line-height: 1.4;">></span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; line-height: 1.4;">0</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">Then</span></div>
<div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">            </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">If</span><span style="font-family: inherit; line-height: 1.4;"> rangeSheet1</span><span style="font-family: inherit; line-height: 1.4;">.</span><span style="font-family: inherit; line-height: 1.4;">Value </span><span style="font-family: inherit; line-height: 1.4;">=</span><span style="font-family: inherit; line-height: 1.4;"> txtNama</span><span style="font-family: inherit; line-height: 1.4;">.</span><span style="font-family: inherit; line-height: 1.4;">Text </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">Then</span></div>
<div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">                rangeSheet1</span><span style="font-family: inherit; line-height: 1.4;">.</span><span style="font-family: inherit; line-height: 1.4;">EntireRow</span><span style="font-family: inherit; line-height: 1.4;">.</span><span style="font-family: inherit; line-height: 1.4;">Delete</span></div>
<div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">                btnTambah.Enabled = True</span></div>
btnTambah.SetFocus
<div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">                </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">Exit</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">For</span></div>
<div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">            </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">End</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">If</span></div>
<div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">        </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">Else</span></div>
<div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">            </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">Exit</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">For</span></div>
<div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">        </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">End</span><span style="font-family: inherit; line-height: 1.4;"> </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">If</span></div>
<div style="text-align: justify;">
<span style="font-family: inherit; line-height: 1.4;">    </span><span style="font-family: inherit; font-weight: bold; line-height: 1.4;">Next</span><span style="font-family: inherit; line-height: 1.4;"> i</span></div>
</span></pre>
</li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Simpan worksheet Anda dengan menekan tombol CTRL+S.</span></li>
</ol>
<h3 style="line-height: 1.4; margin: 0px; position: relative; text-align: justify;">
<span style="background-color: white; font-family: inherit; font-size: small;">Menambahkan Tombol pada Worksheet</span></h3>
</div>
<div>
<ol>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Kembali ke worksheet Anda, tambahkan button control menggunakan menu</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Insert</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">yang terdapat pada tab Developer.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: none;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLP7DgUiDtO9-KcJM5PtqqisK1MlaTe0u3uyjdyjAWmmvjXMzlGLVGRW6UeZ-SlvIGwJqxsDJkedxoyTHEnkeVsMmLv-RPY_y1KOjl-yglpcNZpogM-pll8jL6XO0tZnuf5DIIPyMuggU/s1600/insert_button_worksheet.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: none;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLP7DgUiDtO9-KcJM5PtqqisK1MlaTe0u3uyjdyjAWmmvjXMzlGLVGRW6UeZ-SlvIGwJqxsDJkedxoyTHEnkeVsMmLv-RPY_y1KOjl-yglpcNZpogM-pll8jL6XO0tZnuf5DIIPyMuggU/s1600/insert_button_worksheet.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLP7DgUiDtO9-KcJM5PtqqisK1MlaTe0u3uyjdyjAWmmvjXMzlGLVGRW6UeZ-SlvIGwJqxsDJkedxoyTHEnkeVsMmLv-RPY_y1KOjl-yglpcNZpogM-pll8jL6XO0tZnuf5DIIPyMuggU/s1600/insert_button_worksheet.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" /></a></div>
</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Pada dialog Assign Macro yang muncul. Klik tombol <b>New</b>.</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Pada editor yang muncul tambahkan kode berikut pada</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">Button1_Click()</span><span style="background-color: white; font-family: inherit; line-height: 1.4;">.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
</span><pre style="line-height: 1.4; text-align: justify;"><span style="background-color: white; font-family: inherit;">FormEntri.Show</span></pre>
</li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Pada editor yang muncul tambahkan kode berikut pada </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">Button1_Click()</span><span style="background-color: white; font-family: inherit; line-height: 1.4;">.Kembali ke worksheet, klik kanan pada tombol tersebut dan pilih</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Format Control</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">. Klik tab</span><b style="font-family: inherit; line-height: 1.4;">Properties</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">, dan pilih</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Don't move or size with cells</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">. Tekan tombol</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">OK</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: none;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmlJfN-GlFHx_RwjGPz7iMsv5p8uMGjn5_4jrRy9AYFxXN6qvcSaOQlns1usneQXlt5s_4EJExciVTiz-cQQz5GGEdUuz0joBzMvB0p9pMAHDsyNlEkRNZWmNqrxY5yIujcsnv_Smrb3s/s1600/dont_move_or_size_with_cells-compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: none;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmlJfN-GlFHx_RwjGPz7iMsv5p8uMGjn5_4jrRy9AYFxXN6qvcSaOQlns1usneQXlt5s_4EJExciVTiz-cQQz5GGEdUuz0joBzMvB0p9pMAHDsyNlEkRNZWmNqrxY5yIujcsnv_Smrb3s/s1600/dont_move_or_size_with_cells-compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmlJfN-GlFHx_RwjGPz7iMsv5p8uMGjn5_4jrRy9AYFxXN6qvcSaOQlns1usneQXlt5s_4EJExciVTiz-cQQz5GGEdUuz0joBzMvB0p9pMAHDsyNlEkRNZWmNqrxY5yIujcsnv_Smrb3s/s1600/dont_move_or_size_with_cells-compressed.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" /></a></div>
</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Hasil akhir</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><i style="font-family: inherit; line-height: 1.4;">worksheet</i><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">Anda akan terlihat kira-kira seperti pada</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><i style="font-family: inherit; line-height: 1.4;">screenshot</i><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">berikut.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: none;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKy6SvrQCEJ-kDHy2x4jbbGPzauZGYTiPQ2z1BKC9SRGd5lymvvN73ilgkWT5QID5wk4iWd8WPmJ-VUgfup2a71Kfk8bZeDR45pTma_5-Yma5mvbuZgYVe2PXcMklBcriD_bGQNhkzJHU/s1600/worksheet_button1-compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: none;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKy6SvrQCEJ-kDHy2x4jbbGPzauZGYTiPQ2z1BKC9SRGd5lymvvN73ilgkWT5QID5wk4iWd8WPmJ-VUgfup2a71Kfk8bZeDR45pTma_5-Yma5mvbuZgYVe2PXcMklBcriD_bGQNhkzJHU/s1600/worksheet_button1-compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKy6SvrQCEJ-kDHy2x4jbbGPzauZGYTiPQ2z1BKC9SRGd5lymvvN73ilgkWT5QID5wk4iWd8WPmJ-VUgfup2a71Kfk8bZeDR45pTma_5-Yma5mvbuZgYVe2PXcMklBcriD_bGQNhkzJHU/s1600/worksheet_button1-compressed.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" /></a></div>
</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Simpan <i>worksheet</i> Anda dengan menekan tombol CTRL+S.</span></li>
</ol>
<div style="line-height: 1.4;">
<h3 style="margin: 0px; position: relative; text-align: justify;">
<span style="background-color: white; font-family: inherit; font-size: small;">Menjalankan Form Anda</span></h3>
</div>
</div>
<div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit;">Form Anda sudah selesai dibuat, saatnya kita coba apa yang bisa diperbuat oleh form ini.</span></div>
<div>
<ol>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Kembali ke worksheet Anda, klik tombol <b>Button 1</b>.</span></li>
<li style="margin: 0px 0px 0.25em; padding: 0px;"><div style="line-height: 1.4; text-align: justify;">
<span style="background-color: white; font-family: inherit; line-height: 1.4;">Pada textbox, masukkan teks</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">Coba</b><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">dan klik tombol Tambah sebanyak 3 kali. Kemudian ganti isi textbox dengan</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><b style="font-family: inherit; line-height: 1.4;">BelajarExcel</b><span style="background-color: white; font-family: inherit; line-height: 1.4;">, dan klik tombol Tambah sebanyak 2 kali. Hasilnya akan terlihat seperti pada</span><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><i style="font-family: inherit; line-height: 1.4;">screenshot</i><span style="background-color: white; font-family: inherit; line-height: 1.4;"> </span><span style="background-color: white; font-family: inherit; line-height: 1.4;">berikut.</span></div>
<span style="background-color: white;"><div style="text-align: justify;">
<span style="line-height: 22.3999996185303px;"><br /></span></div>
<div style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: justify; text-decoration: none;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhabGmm9bhteyUpq8qbnNYDv0iqSOin_31rWxCebytyNXvmYCF81GwLCPY62qtQakMy1l6J59RxULYglO6egUg30d7O-c4QIqRfDYt19qLy7xo6vPsEtA9fb2LOojC0uWHEp8IdC6yO40E/s1600/hasil-jalannya-form-compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-align: center; text-decoration: none;"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhabGmm9bhteyUpq8qbnNYDv0iqSOin_31rWxCebytyNXvmYCF81GwLCPY62qtQakMy1l6J59RxULYglO6egUg30d7O-c4QIqRfDYt19qLy7xo6vPsEtA9fb2LOojC0uWHEp8IdC6yO40E/s1600/hasil-jalannya-form-compressed.png" style="font-family: inherit; line-height: 1.4; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhabGmm9bhteyUpq8qbnNYDv0iqSOin_31rWxCebytyNXvmYCF81GwLCPY62qtQakMy1l6J59RxULYglO6egUg30d7O-c4QIqRfDYt19qLy7xo6vPsEtA9fb2LOojC0uWHEp8IdC6yO40E/s1600/hasil-jalannya-form-compressed.png" style="-webkit-box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 1px solid rgb(238, 238, 238); box-shadow: rgba(0, 0, 0, 0.0980392) 1px 1px 5px; padding: 5px; position: relative;" /></a></div>
</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Masih dengan entri teks yang sama, coba klik tombol Hapus. Terlihat bahwa baris pertama ditemukannya teks BelajarExcel yaitu baris ke 4 akan dihapus.</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Cobalah ubah teks menjadi Coba, klik tombol Hapus sebanyak dua kali. Terlihat bahwa baris pertama dan kedua yang berisi teks Coba akan dihapus.</span></li>
<li style="line-height: 1.4; margin: 0px 0px 0.25em; padding: 0px; text-align: justify;"><span style="background-color: white; font-family: inherit;">Selesai.</span></li>
</ol>
</div>
</div>
</p>

Visual Basic for Application atau VBA adalah sebuah bahasa pemrograman yang dibuat oleh Microsoft dan dapat digunakan untuk meningkatk...

Latihan Membuat Macro Excel 2007 - 2010 - 2013