Visual Basic Aplication

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

Visual Basic Aplication

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

Read more »

Membuat Link URL di VBA Microsoft Excel

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

Membuat Link URL di VBA Microsoft Excel

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

Read more »

CARA MEMODIFIKASI RIBBON DI MICROSOFT EXCEL

<div dir="ltr" style="text-align: left;" trbidi="on"> <div class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 7.2pt; text-align: justify; vertical-align: baseline;"> <div class="separator" style="clear: both; text-align: center;"> </div> <div align="center" class="MsoNormal" style="background: white; line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: center; vertical-align: baseline;"> <span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 12.0pt; text-decoration: none;"><!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"> <v:stroke joinstyle="miter"/> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"/> <v:f eqn="sum @0 1 0"/> <v:f eqn="sum 0 0 @1"/> <v:f eqn="prod @2 1 2"/> <v:f eqn="prod @3 21600 pixelWidth"/> <v:f eqn="prod @3 21600 pixelHeight"/> <v:f eqn="sum @0 0 1"/> <v:f eqn="prod @6 1 2"/> <v:f eqn="prod @7 21600 pixelWidth"/> <v:f eqn="sum @8 21600 0"/> <v:f eqn="prod @7 21600 pixelHeight"/> <v:f eqn="sum @10 21600 0"/> </v:formulas> <v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/> <o:lock v:ext="edit" aspectratio="t"/> </v:shapetype><v:shape id="Picture_x0020_3" o:spid="_x0000_i1025" type="#_x0000_t75" alt="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXQF1MqV25gLDiraeoYfudlQRjEJhX3O5aMS9TnBKHn4AegIR61-uLjKx0_IMQQagVEpGIhyPIJRgmLOdksJuVC_FoB1yue2wPyRyOI9y4kEW6G_i_OnvsShoDxjCGBKJPGIt9gQqoBnJu/s320/RIBBON+EXCEL.jpg" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXQF1MqV25gLDiraeoYfudlQRjEJhX3O5aMS9TnBKHn4AegIR61-uLjKx0_IMQQagVEpGIhyPIJRgmLOdksJuVC_FoB1yue2wPyRyOI9y4kEW6G_i_OnvsShoDxjCGBKJPGIt9gQqoBnJu/s1600/RIBBON+EXCEL.jpg" style='width:240pt;height:122.25pt;visibility:visible;mso-wrap-style:square' o:button="t"> <v:imagedata src="file:///C:\Users\DESAPA~1\AppData\Local\Temp\msohtmlclip1\01\clip_image001.jpg" o:title="RIBBON%2BEXCEL"/> </v:shape><![endif]--><!--[if !vml]--><span style="mso-ignore: vglayout;"></span><!--[endif]--></span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="background: white; line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify; vertical-align: baseline;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQnwdOMymek8waWCGGTOrgDUDOjbobXMI5tFD9EmTqSlJ8H-lVG45rgi_QfgASuSpmrsxWeKVOAdYuEsQLlbKD7YrdTHqqYqmSXx3lOriANSl2isbwuoa6jIL2pXAsjK1ODT7kDAUVOZJp/s1600/RIBBON+EXCEL.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="color: black;"><img border="0" data-original-height="328" data-original-width="640" height="164" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiQnwdOMymek8waWCGGTOrgDUDOjbobXMI5tFD9EmTqSlJ8H-lVG45rgi_QfgASuSpmrsxWeKVOAdYuEsQLlbKD7YrdTHqqYqmSXx3lOriANSl2isbwuoa6jIL2pXAsjK1ODT7kDAUVOZJp/s320/RIBBON+EXCEL.jpg" width="320" /></span></a></div> <br /> <div class="MsoNormal" style="background: white; line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify; vertical-align: baseline;"> <span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;"><b>Sobat Genk IT....</b></span><br /> <span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;"><b><br /></b></span> <span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;"><b>Sobat pernah menggunakan aplikasi berbasis VBA Microsoft Excel? aplikasi tersebut telah memodifikasi menu ribbon Microsoft Excel? Kok Bisa? Gimana Cara membuat Menu Ribbon Di Excel tersebut? </b></span><br /> <span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">Memodifikasi ribbon menu di Microsoft Excel sebenarnya sangat mdah, hanya  membutuhkan tool-tool atau software tambahan tertentu dan ketekunan dan semangat untuk belajar </span><span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">saja.</span><br /> <span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;"><br /></span> <b><span style="border: none 1.0pt; font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt; padding: 0cm;">Langkah-langkah memodifikasi menu ribbon Microsoft Excel</span></b></div> <div class="MsoNormal" style="line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;"> <span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">Sebelum mengunduh software Custom UI Editor, silahkan membuat file excel yang bisa digunakan untuk menyisipkan kode macro biasanya type (excel macro) atau extensinya .xlsm</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify;"> <span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;"><br /></span> <span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;">1.</span><span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;"> <span style="color: black;">Download </span><span style="color: blue;"><b><a href="https://desapanunggalan.blogspot.com/2020/06/link-download-ribbon-editor.html" target="_blank">OfficeCustomUIEditorSetup</a></b></span></span><span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;"> (size 228 kb)</span></div> <div class="MsoNormal" style="line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 14.2pt; margin-right: 0cm; margin-top: 0cm; text-align: justify;"> <span style="font-family: "trebuchet ms" , sans-serif;"><span style="font-size: 14px;">Software ini freeware alias Gratis... tenang saja sob....</span></span></div> <div class="MsoNormal" style="background: white; line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify; vertical-align: baseline;"> <span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">2. Setelah terunduh, buka Software tersebut dengan aplikasi <b>Winrar</b></span></div> <div class="MsoNormal" style="background: white; line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify; vertical-align: baseline;"> <span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">3. Buka software, kemuadian double klik </span><span style="font-family: "trebuchet ms" , sans-serif; font-size: 14px;"><b>OfficeCustomUIEditorSetup.msi </b> untuk instalasi</span></div> <div class="MsoNormal" style="background: white; line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; text-align: justify; vertical-align: baseline;"> <span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;"><br /></span> <b><span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">Mengoperasikan </span><span style="font-family: "trebuchet ms" , sans-serif; font-size: 14px;">Office CustomUI Editor</span></b><br />  <span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;">1. Aktifkan Software tersebut, kemudian buka aplikasi yang akan di modif di menu </span><b style="font-family: "trebuchet ms", sans-serif; font-size: 10.5pt;">File > Open</b><span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;"> </span><br /> <span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">    atau klik icon Open</span><br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEid-sZaGjW3WvhcZluMI1U1bFDMreXESZkES3k2mE132sEJJ9lQyTtAs8zgjDhrs3ukiefVYNcvJNTCbOAf_sHUdjmoIu7ICrQEEBOZBX0oizoDdKrA7ve5Dz0OIK9fVDAmDtWrE2JYD5F-/s1600/MODIF+RIBBON.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="543" data-original-width="800" height="217" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEid-sZaGjW3WvhcZluMI1U1bFDMreXESZkES3k2mE132sEJJ9lQyTtAs8zgjDhrs3ukiefVYNcvJNTCbOAf_sHUdjmoIu7ICrQEEBOZBX0oizoDdKrA7ve5Dz0OIK9fVDAmDtWrE2JYD5F-/s320/MODIF+RIBBON.JPG" width="320" /></a></div> <span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;"><br /></span> <span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;">2. Buka File Excel yang dimodifikasi (jika tidak tampil, pilih kategori <b>All Files) <i>buat latihan, silahkan</i></b></span><br /> <span style="font-family: "trebuchet ms" , sans-serif;"><b><i><span style="font-size: 10.5pt;">   unduh File SIAP Desa </span><a href="https://desapanunggalan.blogspot.com/2020/06/link-download2.html" target="_blank">DISINI</a></i></b></span><br /> <span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;">3. Akan tampil sebagai berikut (Ribbon telah dimodif), coba lakukan latihan dengan menampilkan NEW,</span><br /> <span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;">    caranya di script </span><span style="font-family: "trebuchet ms" , sans-serif;"><span style="font-size: 14px;"><button idMso="FileNew" visible="<b>false</b>"/> , falase rubahlah <b>true.</b></span></span><br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizQSodlOhPuMFCZdUjxgd0EkkPZ0nNzc2jwuCu_3M9uEponCJwJDmoYGAXMOMkmYse16vmI04DwmLhvzWX7Ht9h8Swde1S13HQkju0posDDGfzFvpw5lxcwjyiLuA4sV9MF8rtI_1QUyHn/s1600/MODIF+RIBBON+-+Copy+%25282%2529.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="555" data-original-width="800" height="222" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizQSodlOhPuMFCZdUjxgd0EkkPZ0nNzc2jwuCu_3M9uEponCJwJDmoYGAXMOMkmYse16vmI04DwmLhvzWX7Ht9h8Swde1S13HQkju0posDDGfzFvpw5lxcwjyiLuA4sV9MF8rtI_1QUyHn/s320/MODIF+RIBBON+-+Copy+%25282%2529.JPG" width="320" /></a></div> <div class="MsoNormal" style="line-height: 17pt; margin-bottom: 0cm;"> <span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">4. Selanjutnya untuk mengecek klik menu <b style="mso-bidi-font-weight: normal;">validate</b></span><span style="font-family: "times new roman" , "serif"; font-size: 12pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; line-height: 17pt; margin-bottom: 0cm; vertical-align: baseline;"> <span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">5. Apabila sudah oke maka silahkan klik <b>simpan </b></span></div> <div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; line-height: 17pt; margin-bottom: 0cm; vertical-align: baseline;"> <span style="font-family: "trebuchet ms" , "sans-serif"; font-size: 10.5pt;">6. Selanjutnya Klik <b>File  > </b></span><span style="font-family: "trebuchet ms" , sans-serif; font-size: 10.5pt;"><b>Close</b></span></div> <span style="font-family: "trebuchet ms" , sans-serif;"><span style="font-size: 14px;">8. Kemudian Bukalah file exel tersebut, <b>tralalaaaaaaaa LIHATLAH PERUBAHANNYA...</b></span></span><br /> <div> <br /></div> <div> <span style="font-family: "trebuchet ms" , sans-serif; font-size: 14px;">Silahkan mencoba, semoga bermanfaat</span></div> </div> <div class="MsoNormal" style="background: white; line-height: 17.0pt; margin-bottom: .0001pt; margin-bottom: 0cm; margin-left: 14.2pt; margin-right: 0cm; margin-top: 0cm; text-align: justify; vertical-align: baseline;"> <br /></div> </div> </div>

CARA MEMODIFIKASI RIBBON DI MICROSOFT EXCEL

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

Read more »