VBA: Menggunakan Form pada Excel 2010

Ada cukup banyak jenis form yang dapat digunakan bersama VBA di Excel,tapi jika yang dimaksud adalah form yang dapat kita buat dengan fleksibel maka itu adalah UserForm.

Artikel berikut akan menunjukkan cara membuat userForm,menambahkan kontrol di atasnya dan memasukkan kode VBA sehingga dapat berinteraksi dengan worksheet Excel 2010.

Menambahkan dan Menyusun Layout Form

  1. Jalankan aplikasi Microsoft Excel 2010.
  2. Buat dan simpan worksheet baru dengan nama userform-excel-2010.xlsm.
  3. Tekan CTRL+F11 untuk membuka Visual Basic Editor. Jika penekanan tombol tersebut tidak berhasil,klik tab menu Developer dan pilih Visual Basic.
  4. Pada bagian jendela Project Explorer klik kanan pada node VBA Project dan pilih menu Insert diikuti UserForm.

  5. Akan muncul satu form dengan nama UserForm1. Muncul juga satu dialog Toolbox dimana kita bisa mengambil berbagai kontrol untuk diletakkan pada form,dan terakhir ada panel Properties yang bisa gunakan untuk melakukan konfigurasi form maupun kontrol.

  6. Pada Properties,rubah nama dari UserForm1 menjadi FormEntri. Pada caption,rubah teks UserForm1 menjadi Form Entri.
  7. Pada Toolbox,klik kontrol Label.

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

  9. Pada Properties,namakan label tersebut dengan mengisi teks pada bagian Name dengan lblNama dan pada Caption isi dengan teks Nama.
  10. Klik area pada form untuk memunculkan kembali Toolbox. Tambahkan kontrol Textbox pada form dengan cara seperti pada langkah 7 dan 8.

  11. Pada Properties,namakan textbox tersebut dengan mengisi txtNama pada bagian Name.
  12. Klik area pada form untuk memunculkan kembali Toolbox.
  13. Tambahkan dua kontrol command button pada form. Isi Name untuk masing-masing tersebut dengan btnHapus dan btnTambah. Caption untuk btnHapus diisi dengan teks Hapus,dan untuk btnTambah dengan teks Tambah.
  14. Tampilan form akhir Anda akan terlihat seperti pada gambar screenshot berikut ini.

  15. Simpan worksheet Anda dengan menekan tombol CTRL+S.

Menambahkan Kode VBA

  1. Klik dua kali pada tombol dengan caption Tambah sehingga memunculkan editor dengan teks berikut.

  2. Tambahkan kode berikut ke dalam fungsiDim rangeSheet1As RangeFor i=1To Sheet1.Rows.CountSet rangeSheet1= Range(“A”& i)IfLen(rangeSheet1.Value)=0Then rangeSheet1.Value= txtNama.TextExitForEndIfNext i
  3. Klik dua kali pada tombol dengan caption Hapus dan tambahkan kode berikut ke dalam  fungsi Dim%MINIFYHTML21c63dccea82234f8d174151624edd911638%%MINIFYHTML21c63dccea82234f8d174151624edd911639%%MINIFYHTML21c63dccea82234f8d174151624edd911640%%MINIFYHTML21c63dccea82234f8d174151624edd911641%%MINIFYHTML21c63dccea82234f8d174151624edd911642% rangeSheet1%MINIFYHTML21c63dccea82234f8d174151624edd911643%%MINIFYHTML21c63dccea82234f8d174151624edd911644%%MINIFYHTML21c63dccea82234f8d174151624edd911645%%MINIFYHTML21c63dccea82234f8d174151624edd911646%%MINIFYHTML21c63dccea82234f8d174151624edd911647%%MINIFYHTML21c63dccea82234f8d174151624edd911648%%MINIFYHTML21c63dccea82234f8d174151624edd911649%%MINIFYHTML21c63dccea82234f8d174151624edd911650%%MINIFYHTML21c63dccea82234f8d174151624edd911651%%MINIFYHTML21c63dccea82234f8d174151624edd911652%%MINIFYHTML21c63dccea82234f8d174151624edd911653%%MINIFYHTML21c63dccea82234f8d174151624edd911654%As%MINIFYHTML21c63dccea82234f8d174151624edd911655%%MINIFYHTML21c63dccea82234f8d174151624edd911656%%MINIFYHTML21c63dccea82234f8d174151624edd911657%%MINIFYHTML21c63dccea82234f8d174151624edd911658%%MINIFYHTML21c63dccea82234f8d174151624edd911659% Range

    btnTambah.Enabled = False
    %MINIFYHTML21c63dccea82234f8d174151624edd911660%%MINIFYHTML21c63dccea82234f8d174151624edd911661%%MINIFYHTML21c63dccea82234f8d174151624edd911662%%MINIFYHTML21c63dccea82234f8d174151624edd911663%%MINIFYHTML21c63dccea82234f8d174151624edd911664%%MINIFYHTML21c63dccea82234f8d174151624edd911665%%MINIFYHTML21c63dccea82234f8d174151624edd911666%%MINIFYHTML21c63dccea82234f8d174151624edd911667%%MINIFYHTML21c63dccea82234f8d174151624edd911668%%MINIFYHTML21c63dccea82234f8d174151624edd911669%%MINIFYHTML21c63dccea82234f8d174151624edd911670%%MINIFYHTML21c63dccea82234f8d174151624edd911671%For%MINIFYHTML21c63dccea82234f8d174151624edd911672%%MINIFYHTML21c63dccea82234f8d174151624edd911673%%MINIFYHTML21c63dccea82234f8d174151624edd911674%%MINIFYHTML21c63dccea82234f8d174151624edd911675%%MINIFYHTML21c63dccea82234f8d174151624edd911676% i%MINIFYHTML21c63dccea82234f8d174151624edd911677%%MINIFYHTML21c63dccea82234f8d174151624edd911678%%MINIFYHTML21c63dccea82234f8d174151624edd911679%%MINIFYHTML21c63dccea82234f8d174151624edd911680%%MINIFYHTML21c63dccea82234f8d174151624edd911681%%MINIFYHTML21c63dccea82234f8d174151624edd911682%%MINIFYHTML21c63dccea82234f8d174151624edd911683%%MINIFYHTML21c63dccea82234f8d174151624edd911684%%MINIFYHTML21c63dccea82234f8d174151624edd911685%%MINIFYHTML21c63dccea82234f8d174151624edd911686%%MINIFYHTML21c63dccea82234f8d174151624edd911687%%MINIFYHTML21c63dccea82234f8d174151624edd911688%=%MINIFYHTML21c63dccea82234f8d174151624edd911689%%MINIFYHTML21c63dccea82234f8d174151624edd911690%%MINIFYHTML21c63dccea82234f8d174151624edd911691%%MINIFYHTML21c63dccea82234f8d174151624edd911692%%MINIFYHTML21c63dccea82234f8d174151624edd911693%%MINIFYHTML21c63dccea82234f8d174151624edd911694%%MINIFYHTML21c63dccea82234f8d174151624edd911695%%MINIFYHTML21c63dccea82234f8d174151624edd911696%%MINIFYHTML21c63dccea82234f8d174151624edd911697%%MINIFYHTML21c63dccea82234f8d174151624edd911698%%MINIFYHTML21c63dccea82234f8d174151624edd911699%%MINIFYHTML21c63dccea82234f8d174151624edd911700%%MINIFYHTML21c63dccea82234f8d174151624edd911701%%MINIFYHTML21c63dccea82234f8d174151624edd911702%%MINIFYHTML21c63dccea82234f8d174151624edd911703%%MINIFYHTML21c63dccea82234f8d174151624edd911704%%MINIFYHTML21c63dccea82234f8d174151624edd911705%1%MINIFYHTML21c63dccea82234f8d174151624edd911706%%MINIFYHTML21c63dccea82234f8d174151624edd911707%%MINIFYHTML21c63dccea82234f8d174151624edd911708%%MINIFYHTML21c63dccea82234f8d174151624edd911709%%MINIFYHTML21c63dccea82234f8d174151624edd911710%%MINIFYHTML21c63dccea82234f8d174151624edd911711%%MINIFYHTML21c63dccea82234f8d174151624edd911712%%MINIFYHTML21c63dccea82234f8d174151624edd911713%%MINIFYHTML21c63dccea82234f8d174151624edd911714%%MINIFYHTML21c63dccea82234f8d174151624edd911715%%MINIFYHTML21c63dccea82234f8d174151624edd911716%%MINIFYHTML21c63dccea82234f8d174151624edd911717%%MINIFYHTML21c63dccea82234f8d174151624edd911718%%MINIFYHTML21c63dccea82234f8d174151624edd911719%%MINIFYHTML21c63dccea82234f8d174151624edd911720%%MINIFYHTML21c63dccea82234f8d174151624edd911721%%MINIFYHTML21c63dccea82234f8d174151624edd911722%To%MINIFYHTML21c63dccea82234f8d174151624edd911723%%MINIFYHTML21c63dccea82234f8d174151624edd911724%%MINIFYHTML21c63dccea82234f8d174151624edd911725%%MINIFYHTML21c63dccea82234f8d174151624edd911726%%MINIFYHTML21c63dccea82234f8d174151624edd911727% Sheet1%MINIFYHTML21c63dccea82234f8d174151624edd911728%%MINIFYHTML21c63dccea82234f8d174151624edd911729%%MINIFYHTML21c63dccea82234f8d174151624edd911730%%MINIFYHTML21c63dccea82234f8d174151624edd911731%%MINIFYHTML21c63dccea82234f8d174151624edd911732%%MINIFYHTML21c63dccea82234f8d174151624edd911733%%MINIFYHTML21c63dccea82234f8d174151624edd911734%%MINIFYHTML21c63dccea82234f8d174151624edd911735%%MINIFYHTML21c63dccea82234f8d174151624edd911736%%MINIFYHTML21c63dccea82234f8d174151624edd911737%%MINIFYHTML21c63dccea82234f8d174151624edd911738%%MINIFYHTML21c63dccea82234f8d174151624edd911739%.%MINIFYHTML21c63dccea82234f8d174151624edd911740%%MINIFYHTML21c63dccea82234f8d174151624edd911741%%MINIFYHTML21c63dccea82234f8d174151624edd911742%%MINIFYHTML21c63dccea82234f8d174151624edd911743%%MINIFYHTML21c63dccea82234f8d174151624edd911744%Rows%MINIFYHTML21c63dccea82234f8d174151624edd911745%%MINIFYHTML21c63dccea82234f8d174151624edd911746%%MINIFYHTML21c63dccea82234f8d174151624edd911747%%MINIFYHTML21c63dccea82234f8d174151624edd911748%%MINIFYHTML21c63dccea82234f8d174151624edd911749%%MINIFYHTML21c63dccea82234f8d174151624edd911750%%MINIFYHTML21c63dccea82234f8d174151624edd911751%%MINIFYHTML21c63dccea82234f8d174151624edd911752%%MINIFYHTML21c63dccea82234f8d174151624edd911753%%MINIFYHTML21c63dccea82234f8d174151624edd911754%%MINIFYHTML21c63dccea82234f8d174151624edd911755%%MINIFYHTML21c63dccea82234f8d174151624edd911756%.%MINIFYHTML21c63dccea82234f8d174151624edd911757%%MINIFYHTML21c63dccea82234f8d174151624edd911758%%MINIFYHTML21c63dccea82234f8d174151624edd911759%%MINIFYHTML21c63dccea82234f8d174151624edd911760%%MINIFYHTML21c63dccea82234f8d174151624edd911761%Count
    %MINIFYHTML21c63dccea82234f8d174151624edd911762%%MINIFYHTML21c63dccea82234f8d174151624edd911763%%MINIFYHTML21c63dccea82234f8d174151624edd911764%%MINIFYHTML21c63dccea82234f8d174151624edd911765%%MINIFYHTML21c63dccea82234f8d174151624edd911766%%MINIFYHTML21c63dccea82234f8d174151624edd911767%%MINIFYHTML21c63dccea82234f8d174151624edd911768%%MINIFYHTML21c63dccea82234f8d174151624edd911769%%MINIFYHTML21c63dccea82234f8d174151624edd911770%%MINIFYHTML21c63dccea82234f8d174151624edd911771%%MINIFYHTML21c63dccea82234f8d174151624edd911772%%MINIFYHTML21c63dccea82234f8d174151624edd911773%Set%MINIFYHTML21c63dccea82234f8d174151624edd911774%%MINIFYHTML21c63dccea82234f8d174151624edd911775%%MINIFYHTML21c63dccea82234f8d174151624edd911776%%MINIFYHTML21c63dccea82234f8d174151624edd911777%%MINIFYHTML21c63dccea82234f8d174151624edd911778% rangeSheet1%MINIFYHTML21c63dccea82234f8d174151624edd911779%%MINIFYHTML21c63dccea82234f8d174151624edd911780%%MINIFYHTML21c63dccea82234f8d174151624edd911781%%MINIFYHTML21c63dccea82234f8d174151624edd911782%%MINIFYHTML21c63dccea82234f8d174151624edd911783%%MINIFYHTML21c63dccea82234f8d174151624edd911784%%MINIFYHTML21c63dccea82234f8d174151624edd911785%%MINIFYHTML21c63dccea82234f8d174151624edd911786%%MINIFYHTML21c63dccea82234f8d174151624edd911787%%MINIFYHTML21c63dccea82234f8d174151624edd911788%%MINIFYHTML21c63dccea82234f8d174151624edd911789%%MINIFYHTML21c63dccea82234f8d174151624edd911790%=%MINIFYHTML21c63dccea82234f8d174151624edd911791%%MINIFYHTML21c63dccea82234f8d174151624edd911792%%MINIFYHTML21c63dccea82234f8d174151624edd911793%%MINIFYHTML21c63dccea82234f8d174151624edd911794%%MINIFYHTML21c63dccea82234f8d174151624edd911795% Range%MINIFYHTML21c63dccea82234f8d174151624edd911796%%MINIFYHTML21c63dccea82234f8d174151624edd911797%%MINIFYHTML21c63dccea82234f8d174151624edd911798%%MINIFYHTML21c63dccea82234f8d174151624edd911799%%MINIFYHTML21c63dccea82234f8d174151624edd911800%%MINIFYHTML21c63dccea82234f8d174151624edd911801%%MINIFYHTML21c63dccea82234f8d174151624edd911802%%MINIFYHTML21c63dccea82234f8d174151624edd911803%%MINIFYHTML21c63dccea82234f8d174151624edd911804%%MINIFYHTML21c63dccea82234f8d174151624edd911805%%MINIFYHTML21c63dccea82234f8d174151624edd911806%%MINIFYHTML21c63dccea82234f8d174151624edd911807%(%MINIFYHTML21c63dccea82234f8d174151624edd911808%%MINIFYHTML21c63dccea82234f8d174151624edd911809%%MINIFYHTML21c63dccea82234f8d174151624edd911810%%MINIFYHTML21c63dccea82234f8d174151624edd911811%%MINIFYHTML21c63dccea82234f8d174151624edd911812%%MINIFYHTML21c63dccea82234f8d174151624edd911813%%MINIFYHTML21c63dccea82234f8d174151624edd911814%%MINIFYHTML21c63dccea82234f8d174151624edd911815%%MINIFYHTML21c63dccea82234f8d174151624edd911816%%MINIFYHTML21c63dccea82234f8d174151624edd911817%%MINIFYHTML21c63dccea82234f8d174151624edd911818%%MINIFYHTML21c63dccea82234f8d174151624edd911819%%MINIFYHTML21c63dccea82234f8d174151624edd911820%%MINIFYHTML21c63dccea82234f8d174151624edd911821%%MINIFYHTML21c63dccea82234f8d174151624edd911822%%MINIFYHTML21c63dccea82234f8d174151624edd911823%%MINIFYHTML21c63dccea82234f8d174151624edd911824%"A"%MINIFYHTML21c63dccea82234f8d174151624edd911825%%MINIFYHTML21c63dccea82234f8d174151624edd911826%%MINIFYHTML21c63dccea82234f8d174151624edd911827%%MINIFYHTML21c63dccea82234f8d174151624edd911828%%MINIFYHTML21c63dccea82234f8d174151624edd911829%%MINIFYHTML21c63dccea82234f8d174151624edd911830%%MINIFYHTML21c63dccea82234f8d174151624edd911831%%MINIFYHTML21c63dccea82234f8d174151624edd911832%%MINIFYHTML21c63dccea82234f8d174151624edd911833%%MINIFYHTML21c63dccea82234f8d174151624edd911834%%MINIFYHTML21c63dccea82234f8d174151624edd911835%%MINIFYHTML21c63dccea82234f8d174151624edd911836%%MINIFYHTML21c63dccea82234f8d174151624edd911837%%MINIFYHTML21c63dccea82234f8d174151624edd911838%%MINIFYHTML21c63dccea82234f8d174151624edd911839%%MINIFYHTML21c63dccea82234f8d174151624edd911840%%MINIFYHTML21c63dccea82234f8d174151624edd911841%&%MINIFYHTML21c63dccea82234f8d174151624edd911842%%MINIFYHTML21c63dccea82234f8d174151624edd911843%%MINIFYHTML21c63dccea82234f8d174151624edd911844%%MINIFYHTML21c63dccea82234f8d174151624edd911845%%MINIFYHTML21c63dccea82234f8d174151624edd911846% i%MINIFYHTML21c63dccea82234f8d174151624edd911847%%MINIFYHTML21c63dccea82234f8d174151624edd911848%%MINIFYHTML21c63dccea82234f8d174151624edd911849%%MINIFYHTML21c63dccea82234f8d174151624edd911850%%MINIFYHTML21c63dccea82234f8d174151624edd911851%%MINIFYHTML21c63dccea82234f8d174151624edd911852%%MINIFYHTML21c63dccea82234f8d174151624edd911853%%MINIFYHTML21c63dccea82234f8d174151624edd911854%%MINIFYHTML21c63dccea82234f8d174151624edd911855%%MINIFYHTML21c63dccea82234f8d174151624edd911856%%MINIFYHTML21c63dccea82234f8d174151624edd911857%%MINIFYHTML21c63dccea82234f8d174151624edd911858%)%MINIFYHTML21c63dccea82234f8d174151624edd911859%%MINIFYHTML21c63dccea82234f8d174151624edd911860%%MINIFYHTML21c63dccea82234f8d174151624edd911861%%MINIFYHTML21c63dccea82234f8d174151624edd911862%%MINIFYHTML21c63dccea82234f8d174151624edd911863%
    %MINIFYHTML21c63dccea82234f8d174151624edd911864%%MINIFYHTML21c63dccea82234f8d174151624edd911865%%MINIFYHTML21c63dccea82234f8d174151624edd911866%%MINIFYHTML21c63dccea82234f8d174151624edd911867%%MINIFYHTML21c63dccea82234f8d174151624edd911868%%MINIFYHTML21c63dccea82234f8d174151624edd911869%%MINIFYHTML21c63dccea82234f8d174151624edd911870%%MINIFYHTML21c63dccea82234f8d174151624edd911871%%MINIFYHTML21c63dccea82234f8d174151624edd911872%%MINIFYHTML21c63dccea82234f8d174151624edd911873%%MINIFYHTML21c63dccea82234f8d174151624edd911874%%MINIFYHTML21c63dccea82234f8d174151624edd911875%If%MINIFYHTML21c63dccea82234f8d174151624edd911876%%MINIFYHTML21c63dccea82234f8d174151624edd911877%%MINIFYHTML21c63dccea82234f8d174151624edd911878%%MINIFYHTML21c63dccea82234f8d174151624edd911879%%MINIFYHTML21c63dccea82234f8d174151624edd911880%%MINIFYHTML21c63dccea82234f8d174151624edd911881%%MINIFYHTML21c63dccea82234f8d174151624edd911882%%MINIFYHTML21c63dccea82234f8d174151624edd911883%%MINIFYHTML21c63dccea82234f8d174151624edd911884%%MINIFYHTML21c63dccea82234f8d174151624edd911885%%MINIFYHTML21c63dccea82234f8d174151624edd911886%%MINIFYHTML21c63dccea82234f8d174151624edd911887%%MINIFYHTML21c63dccea82234f8d174151624edd911888%%MINIFYHTML21c63dccea82234f8d174151624edd911889%%MINIFYHTML21c63dccea82234f8d174151624edd911890%%MINIFYHTML21c63dccea82234f8d174151624edd911891%%MINIFYHTML21c63dccea82234f8d174151624edd911892%Len%MINIFYHTML21c63dccea82234f8d174151624edd911893%%MINIFYHTML21c63dccea82234f8d174151624edd911894%%MINIFYHTML21c63dccea82234f8d174151624edd911895%%MINIFYHTML21c63dccea82234f8d174151624edd911896%%MINIFYHTML21c63dccea82234f8d174151624edd911897%%MINIFYHTML21c63dccea82234f8d174151624edd911898%%MINIFYHTML21c63dccea82234f8d174151624edd911899%%MINIFYHTML21c63dccea82234f8d174151624edd911900%%MINIFYHTML21c63dccea82234f8d174151624edd911901%%MINIFYHTML21c63dccea82234f8d174151624edd911902%%MINIFYHTML21c63dccea82234f8d174151624edd911903%%MINIFYHTML21c63dccea82234f8d174151624edd911904%%MINIFYHTML21c63dccea82234f8d174151624edd911905%%MINIFYHTML21c63dccea82234f8d174151624edd911906%%MINIFYHTML21c63dccea82234f8d174151624edd911907%%MINIFYHTML21c63dccea82234f8d174151624edd911908%%MINIFYHTML21c63dccea82234f8d174151624edd911909%(%MINIFYHTML21c63dccea82234f8d174151624edd911910%%MINIFYHTML21c63dccea82234f8d174151624edd911911%%MINIFYHTML21c63dccea82234f8d174151624edd911912%%MINIFYHTML21c63dccea82234f8d174151624edd911913%%MINIFYHTML21c63dccea82234f8d174151624edd911914%rangeSheet1%MINIFYHTML21c63dccea82234f8d174151624edd911915%%MINIFYHTML21c63dccea82234f8d174151624edd911916%%MINIFYHTML21c63dccea82234f8d174151624edd911917%%MINIFYHTML21c63dccea82234f8d174151624edd911918%%MINIFYHTML21c63dccea82234f8d174151624edd911919%%MINIFYHTML21c63dccea82234f8d174151624edd911920%%MINIFYHTML21c63dccea82234f8d174151624edd911921%%MINIFYHTML21c63dccea82234f8d174151624edd911922%%MINIFYHTML21c63dccea82234f8d174151624edd911923%%MINIFYHTML21c63dccea82234f8d174151624edd911924%%MINIFYHTML21c63dccea82234f8d174151624edd911925%%MINIFYHTML21c63dccea82234f8d174151624edd911926%.%MINIFYHTML21c63dccea82234f8d174151624edd911927%%MINIFYHTML21c63dccea82234f8d174151624edd911928%%MINIFYHTML21c63dccea82234f8d174151624edd911929%%MINIFYHTML21c63dccea82234f8d174151624edd911930%%MINIFYHTML21c63dccea82234f8d174151624edd911931%Value%MINIFYHTML21c63dccea82234f8d174151624edd911932%%MINIFYHTML21c63dccea82234f8d174151624edd911933%%MINIFYHTML21c63dccea82234f8d174151624edd911934%%MINIFYHTML21c63dccea82234f8d174151624edd911935%%MINIFYHTML21c63dccea82234f8d174151624edd911936%%MINIFYHTML21c63dccea82234f8d174151624edd911937%%MINIFYHTML21c63dccea82234f8d174151624edd911938%%MINIFYHTML21c63dccea82234f8d174151624edd911939%%MINIFYHTML21c63dccea82234f8d174151624edd911940%%MINIFYHTML21c63dccea82234f8d174151624edd911941%%MINIFYHTML21c63dccea82234f8d174151624edd911942%%MINIFYHTML21c63dccea82234f8d174151624edd911943%)%MINIFYHTML21c63dccea82234f8d174151624edd911944%%MINIFYHTML21c63dccea82234f8d174151624edd911945%%MINIFYHTML21c63dccea82234f8d174151624edd911946%%MINIFYHTML21c63dccea82234f8d174151624edd911947%%MINIFYHTML21c63dccea82234f8d174151624edd911948%%MINIFYHTML21c63dccea82234f8d174151624edd911949%%MINIFYHTML21c63dccea82234f8d174151624edd911950%%MINIFYHTML21c63dccea82234f8d174151624edd911951%%MINIFYHTML21c63dccea82234f8d174151624edd911952%%MINIFYHTML21c63dccea82234f8d174151624edd911953%%MINIFYHTML21c63dccea82234f8d174151624edd911954%%MINIFYHTML21c63dccea82234f8d174151624edd911955%%MINIFYHTML21c63dccea82234f8d174151624edd911956%%MINIFYHTML21c63dccea82234f8d174151624edd911957%%MINIFYHTML21c63dccea82234f8d174151624edd911958%%MINIFYHTML21c63dccea82234f8d174151624edd911959%%MINIFYHTML21c63dccea82234f8d174151624edd911960%>%MINIFYHTML21c63dccea82234f8d174151624edd911961%%MINIFYHTML21c63dccea82234f8d174151624edd911962%%MINIFYHTML21c63dccea82234f8d174151624edd911963%%MINIFYHTML21c63dccea82234f8d174151624edd911964%%MINIFYHTML21c63dccea82234f8d174151624edd911965%%MINIFYHTML21c63dccea82234f8d174151624edd911966%%MINIFYHTML21c63dccea82234f8d174151624edd911967%%MINIFYHTML21c63dccea82234f8d174151624edd911968%%MINIFYHTML21c63dccea82234f8d174151624edd911969%%MINIFYHTML21c63dccea82234f8d174151624edd911970%%MINIFYHTML21c63dccea82234f8d174151624edd911971%%MINIFYHTML21c63dccea82234f8d174151624edd911972%%MINIFYHTML21c63dccea82234f8d174151624edd911973%%MINIFYHTML21c63dccea82234f8d174151624edd911974%%MINIFYHTML21c63dccea82234f8d174151624edd911975%%MINIFYHTML21c63dccea82234f8d174151624edd911976%%MINIFYHTML21c63dccea82234f8d174151624edd911977%0%MINIFYHTML21c63dccea82234f8d174151624edd911978%%MINIFYHTML21c63dccea82234f8d174151624edd911979%%MINIFYHTML21c63dccea82234f8d174151624edd911980%%MINIFYHTML21c63dccea82234f8d174151624edd911981%%MINIFYHTML21c63dccea82234f8d174151624edd911982%%MINIFYHTML21c63dccea82234f8d174151624edd911983%%MINIFYHTML21c63dccea82234f8d174151624edd911984%%MINIFYHTML21c63dccea82234f8d174151624edd911985%%MINIFYHTML21c63dccea82234f8d174151624edd911986%%MINIFYHTML21c63dccea82234f8d174151624edd911987%%MINIFYHTML21c63dccea82234f8d174151624edd911988%%MINIFYHTML21c63dccea82234f8d174151624edd911989%%MINIFYHTML21c63dccea82234f8d174151624edd911990%%MINIFYHTML21c63dccea82234f8d174151624edd911991%%MINIFYHTML21c63dccea82234f8d174151624edd911992%%MINIFYHTML21c63dccea82234f8d174151624edd911993%%MINIFYHTML21c63dccea82234f8d174151624edd911994%Then%MINIFYHTML21c63dccea82234f8d174151624edd911995%%MINIFYHTML21c63dccea82234f8d174151624edd911996%%MINIFYHTML21c63dccea82234f8d174151624edd911997%%MINIFYHTML21c63dccea82234f8d174151624edd911998%%MINIFYHTML21c63dccea82234f8d174151624edd911999%
    %MINIFYHTML21c63dccea82234f8d174151624edd912000%%MINIFYHTML21c63dccea82234f8d174151624edd912001%%MINIFYHTML21c63dccea82234f8d174151624edd912002%%MINIFYHTML21c63dccea82234f8d174151624edd912003%%MINIFYHTML21c63dccea82234f8d174151624edd912004%%MINIFYHTML21c63dccea82234f8d174151624edd912005%%MINIFYHTML21c63dccea82234f8d174151624edd912006%%MINIFYHTML21c63dccea82234f8d174151624edd912007%%MINIFYHTML21c63dccea82234f8d174151624edd912008%%MINIFYHTML21c63dccea82234f8d174151624edd912009%%MINIFYHTML21c63dccea82234f8d174151624edd912010%%MINIFYHTML21c63dccea82234f8d174151624edd912011%If%MINIFYHTML21c63dccea82234f8d174151624edd912012%%MINIFYHTML21c63dccea82234f8d174151624edd912013%%MINIFYHTML21c63dccea82234f8d174151624edd912014%%MINIFYHTML21c63dccea82234f8d174151624edd912015%%MINIFYHTML21c63dccea82234f8d174151624edd912016% rangeSheet1%MINIFYHTML21c63dccea82234f8d174151624edd912017%%MINIFYHTML21c63dccea82234f8d174151624edd912018%%MINIFYHTML21c63dccea82234f8d174151624edd912019%%MINIFYHTML21c63dccea82234f8d174151624edd912020%%MINIFYHTML21c63dccea82234f8d174151624edd912021%%MINIFYHTML21c63dccea82234f8d174151624edd912022%%MINIFYHTML21c63dccea82234f8d174151624edd912023%%MINIFYHTML21c63dccea82234f8d174151624edd912024%%MINIFYHTML21c63dccea82234f8d174151624edd912025%%MINIFYHTML21c63dccea82234f8d174151624edd912026%%MINIFYHTML21c63dccea82234f8d174151624edd912027%%MINIFYHTML21c63dccea82234f8d174151624edd912028%.%MINIFYHTML21c63dccea82234f8d174151624edd912029%%MINIFYHTML21c63dccea82234f8d174151624edd912030%%MINIFYHTML21c63dccea82234f8d174151624edd912031%%MINIFYHTML21c63dccea82234f8d174151624edd912032%%MINIFYHTML21c63dccea82234f8d174151624edd912033%Value%MINIFYHTML21c63dccea82234f8d174151624edd912034%%MINIFYHTML21c63dccea82234f8d174151624edd912035%%MINIFYHTML21c63dccea82234f8d174151624edd912036%%MINIFYHTML21c63dccea82234f8d174151624edd912037%%MINIFYHTML21c63dccea82234f8d174151624edd912038%%MINIFYHTML21c63dccea82234f8d174151624edd912039%%MINIFYHTML21c63dccea82234f8d174151624edd912040%%MINIFYHTML21c63dccea82234f8d174151624edd912041%%MINIFYHTML21c63dccea82234f8d174151624edd912042%%MINIFYHTML21c63dccea82234f8d174151624edd912043%%MINIFYHTML21c63dccea82234f8d174151624edd912044%%MINIFYHTML21c63dccea82234f8d174151624edd912045%=%MINIFYHTML21c63dccea82234f8d174151624edd912046%%MINIFYHTML21c63dccea82234f8d174151624edd912047%%MINIFYHTML21c63dccea82234f8d174151624edd912048%%MINIFYHTML21c63dccea82234f8d174151624edd912049%%MINIFYHTML21c63dccea82234f8d174151624edd912050% txtNama%MINIFYHTML21c63dccea82234f8d174151624edd912051%%MINIFYHTML21c63dccea82234f8d174151624edd912052%%MINIFYHTML21c63dccea82234f8d174151624edd912053%%MINIFYHTML21c63dccea82234f8d174151624edd912054%%MINIFYHTML21c63dccea82234f8d174151624edd912055%%MINIFYHTML21c63dccea82234f8d174151624edd912056%%MINIFYHTML21c63dccea82234f8d174151624edd912057%%MINIFYHTML21c63dccea82234f8d174151624edd912058%%MINIFYHTML21c63dccea82234f8d174151624edd912059%%MINIFYHTML21c63dccea82234f8d174151624edd912060%%MINIFYHTML21c63dccea82234f8d174151624edd912061%%MINIFYHTML21c63dccea82234f8d174151624edd912062%.%MINIFYHTML21c63dccea82234f8d174151624edd912063%%MINIFYHTML21c63dccea82234f8d174151624edd912064%%MINIFYHTML21c63dccea82234f8d174151624edd912065%%MINIFYHTML21c63dccea82234f8d174151624edd912066%%MINIFYHTML21c63dccea82234f8d174151624edd912067%Text%MINIFYHTML21c63dccea82234f8d174151624edd912068%%MINIFYHTML21c63dccea82234f8d174151624edd912069%%MINIFYHTML21c63dccea82234f8d174151624edd912070%%MINIFYHTML21c63dccea82234f8d174151624edd912071%%MINIFYHTML21c63dccea82234f8d174151624edd912072%%MINIFYHTML21c63dccea82234f8d174151624edd912073%%MINIFYHTML21c63dccea82234f8d174151624edd912074%%MINIFYHTML21c63dccea82234f8d174151624edd912075%%MINIFYHTML21c63dccea82234f8d174151624edd912076%%MINIFYHTML21c63dccea82234f8d174151624edd912077%%MINIFYHTML21c63dccea82234f8d174151624edd912078%%MINIFYHTML21c63dccea82234f8d174151624edd912079%Then%MINIFYHTML21c63dccea82234f8d174151624edd912080%%MINIFYHTML21c63dccea82234f8d174151624edd912081%%MINIFYHTML21c63dccea82234f8d174151624edd912082%%MINIFYHTML21c63dccea82234f8d174151624edd912083%%MINIFYHTML21c63dccea82234f8d174151624edd912084%
    rangeSheet1%MINIFYHTML21c63dccea82234f8d174151624edd912085%%MINIFYHTML21c63dccea82234f8d174151624edd912086%%MINIFYHTML21c63dccea82234f8d174151624edd912087%%MINIFYHTML21c63dccea82234f8d174151624edd912088%%MINIFYHTML21c63dccea82234f8d174151624edd912089%%MINIFYHTML21c63dccea82234f8d174151624edd912090%%MINIFYHTML21c63dccea82234f8d174151624edd912091%%MINIFYHTML21c63dccea82234f8d174151624edd912092%%MINIFYHTML21c63dccea82234f8d174151624edd912093%%MINIFYHTML21c63dccea82234f8d174151624edd912094%%MINIFYHTML21c63dccea82234f8d174151624edd912095%%MINIFYHTML21c63dccea82234f8d174151624edd912096%.%MINIFYHTML21c63dccea82234f8d174151624edd912097%%MINIFYHTML21c63dccea82234f8d174151624edd912098%%MINIFYHTML21c63dccea82234f8d174151624edd912099%%MINIFYHTML21c63dccea82234f8d174151624edd912100%%MINIFYHTML21c63dccea82234f8d174151624edd912101%EntireRow%MINIFYHTML21c63dccea82234f8d174151624edd912102%%MINIFYHTML21c63dccea82234f8d174151624edd912103%%MINIFYHTML21c63dccea82234f8d174151624edd912104%%MINIFYHTML21c63dccea82234f8d174151624edd912105%%MINIFYHTML21c63dccea82234f8d174151624edd912106%%MINIFYHTML21c63dccea82234f8d174151624edd912107%%MINIFYHTML21c63dccea82234f8d174151624edd912108%%MINIFYHTML21c63dccea82234f8d174151624edd912109%%MINIFYHTML21c63dccea82234f8d174151624edd912110%%MINIFYHTML21c63dccea82234f8d174151624edd912111%%MINIFYHTML21c63dccea82234f8d174151624edd912112%%MINIFYHTML21c63dccea82234f8d174151624edd912113%.%MINIFYHTML21c63dccea82234f8d174151624edd912114%%MINIFYHTML21c63dccea82234f8d174151624edd912115%%MINIFYHTML21c63dccea82234f8d174151624edd912116%%MINIFYHTML21c63dccea82234f8d174151624edd912117%%MINIFYHTML21c63dccea82234f8d174151624edd912118%Delete
    btnTambah.Enabled = True
    btnTambah.SetFocus
    %MINIFYHTML21c63dccea82234f8d174151624edd912119%%MINIFYHTML21c63dccea82234f8d174151624edd912120%%MINIFYHTML21c63dccea82234f8d174151624edd912121%%MINIFYHTML21c63dccea82234f8d174151624edd912122%%MINIFYHTML21c63dccea82234f8d174151624edd912123%%MINIFYHTML21c63dccea82234f8d174151624edd912124%%MINIFYHTML21c63dccea82234f8d174151624edd912125%%MINIFYHTML21c63dccea82234f8d174151624edd912126%%MINIFYHTML21c63dccea82234f8d174151624edd912127%%MINIFYHTML21c63dccea82234f8d174151624edd912128%%MINIFYHTML21c63dccea82234f8d174151624edd912129%%MINIFYHTML21c63dccea82234f8d174151624edd912130%Exit%MINIFYHTML21c63dccea82234f8d174151624edd912131%%MINIFYHTML21c63dccea82234f8d174151624edd912132%%MINIFYHTML21c63dccea82234f8d174151624edd912133%%MINIFYHTML21c63dccea82234f8d174151624edd912134%%MINIFYHTML21c63dccea82234f8d174151624edd912135%%MINIFYHTML21c63dccea82234f8d174151624edd912136%%MINIFYHTML21c63dccea82234f8d174151624edd912137%%MINIFYHTML21c63dccea82234f8d174151624edd912138%%MINIFYHTML21c63dccea82234f8d174151624edd912139%%MINIFYHTML21c63dccea82234f8d174151624edd912140%%MINIFYHTML21c63dccea82234f8d174151624edd912141%%MINIFYHTML21c63dccea82234f8d174151624edd912142%%MINIFYHTML21c63dccea82234f8d174151624edd912143%%MINIFYHTML21c63dccea82234f8d174151624edd912144%%MINIFYHTML21c63dccea82234f8d174151624edd912145%%MINIFYHTML21c63dccea82234f8d174151624edd912146%%MINIFYHTML21c63dccea82234f8d174151624edd912147%For%MINIFYHTML21c63dccea82234f8d174151624edd912148%%MINIFYHTML21c63dccea82234f8d174151624edd912149%%MINIFYHTML21c63dccea82234f8d174151624edd912150%%MINIFYHTML21c63dccea82234f8d174151624edd912151%%MINIFYHTML21c63dccea82234f8d174151624edd912152%
    %MINIFYHTML21c63dccea82234f8d174151624edd912153%%MINIFYHTML21c63dccea82234f8d174151624edd912154%%MINIFYHTML21c63dccea82234f8d174151624edd912155%%MINIFYHTML21c63dccea82234f8d174151624edd912156%%MINIFYHTML21c63dccea82234f8d174151624edd912157%%MINIFYHTML21c63dccea82234f8d174151624edd912158%%MINIFYHTML21c63dccea82234f8d174151624edd912159%%MINIFYHTML21c63dccea82234f8d174151624edd912160%%MINIFYHTML21c63dccea82234f8d174151624edd912161%%MINIFYHTML21c63dccea82234f8d174151624edd912162%%MINIFYHTML21c63dccea82234f8d174151624edd912163%%MINIFYHTML21c63dccea82234f8d174151624edd912164%End%MINIFYHTML21c63dccea82234f8d174151624edd912165%%MINIFYHTML21c63dccea82234f8d174151624edd912166%%MINIFYHTML21c63dccea82234f8d174151624edd912167%%MINIFYHTML21c63dccea82234f8d174151624edd912168%%MINIFYHTML21c63dccea82234f8d174151624edd912169%%MINIFYHTML21c63dccea82234f8d174151624edd912170%%MINIFYHTML21c63dccea82234f8d174151624edd912171%%MINIFYHTML21c63dccea82234f8d174151624edd912172%%MINIFYHTML21c63dccea82234f8d174151624edd912173%%MINIFYHTML21c63dccea82234f8d174151624edd912174%%MINIFYHTML21c63dccea82234f8d174151624edd912175%%MINIFYHTML21c63dccea82234f8d174151624edd912176%%MINIFYHTML21c63dccea82234f8d174151624edd912177%%MINIFYHTML21c63dccea82234f8d174151624edd912178%%MINIFYHTML21c63dccea82234f8d174151624edd912179%%MINIFYHTML21c63dccea82234f8d174151624edd912180%%MINIFYHTML21c63dccea82234f8d174151624edd912181%If%MINIFYHTML21c63dccea82234f8d174151624edd912182%%MINIFYHTML21c63dccea82234f8d174151624edd912183%%MINIFYHTML21c63dccea82234f8d174151624edd912184%%MINIFYHTML21c63dccea82234f8d174151624edd912185%%MINIFYHTML21c63dccea82234f8d174151624edd912186%
    %MINIFYHTML21c63dccea82234f8d174151624edd912187%%MINIFYHTML21c63dccea82234f8d174151624edd912188%%MINIFYHTML21c63dccea82234f8d174151624edd912189%%MINIFYHTML21c63dccea82234f8d174151624edd912190%%MINIFYHTML21c63dccea82234f8d174151624edd912191%%MINIFYHTML21c63dccea82234f8d174151624edd912192%%MINIFYHTML21c63dccea82234f8d174151624edd912193%%MINIFYHTML21c63dccea82234f8d174151624edd912194%%MINIFYHTML21c63dccea82234f8d174151624edd912195%%MINIFYHTML21c63dccea82234f8d174151624edd912196%%MINIFYHTML21c63dccea82234f8d174151624edd912197%%MINIFYHTML21c63dccea82234f8d174151624edd912198%Else%MINIFYHTML21c63dccea82234f8d174151624edd912199%%MINIFYHTML21c63dccea82234f8d174151624edd912200%%MINIFYHTML21c63dccea82234f8d174151624edd912201%%MINIFYHTML21c63dccea82234f8d174151624edd912202%%MINIFYHTML21c63dccea82234f8d174151624edd912203%
    %MINIFYHTML21c63dccea82234f8d174151624edd912204%%MINIFYHTML21c63dccea82234f8d174151624edd912205%%MINIFYHTML21c63dccea82234f8d174151624edd912206%%MINIFYHTML21c63dccea82234f8d174151624edd912207%%MINIFYHTML21c63dccea82234f8d174151624edd912208%%MINIFYHTML21c63dccea82234f8d174151624edd912209%%MINIFYHTML21c63dccea82234f8d174151624edd912210%%MINIFYHTML21c63dccea82234f8d174151624edd912211%%MINIFYHTML21c63dccea82234f8d174151624edd912212%%MINIFYHTML21c63dccea82234f8d174151624edd912213%%MINIFYHTML21c63dccea82234f8d174151624edd912214%%MINIFYHTML21c63dccea82234f8d174151624edd912215%Exit%MINIFYHTML21c63dccea82234f8d174151624edd912216%%MINIFYHTML21c63dccea82234f8d174151624edd912217%%MINIFYHTML21c63dccea82234f8d174151624edd912218%%MINIFYHTML21c63dccea82234f8d174151624edd912219%%MINIFYHTML21c63dccea82234f8d174151624edd912220%%MINIFYHTML21c63dccea82234f8d174151624edd912221%%MINIFYHTML21c63dccea82234f8d174151624edd912222%%MINIFYHTML21c63dccea82234f8d174151624edd912223%%MINIFYHTML21c63dccea82234f8d174151624edd912224%%MINIFYHTML21c63dccea82234f8d174151624edd912225%%MINIFYHTML21c63dccea82234f8d174151624edd912226%%MINIFYHTML21c63dccea82234f8d174151624edd912227%%MINIFYHTML21c63dccea82234f8d174151624edd912228%%MINIFYHTML21c63dccea82234f8d174151624edd912229%%MINIFYHTML21c63dccea82234f8d174151624edd912230%%MINIFYHTML21c63dccea82234f8d174151624edd912231%%MINIFYHTML21c63dccea82234f8d174151624edd912232%For%MINIFYHTML21c63dccea82234f8d174151624edd912233%%MINIFYHTML21c63dccea82234f8d174151624edd912234%%MINIFYHTML21c63dccea82234f8d174151624edd912235%%MINIFYHTML21c63dccea82234f8d174151624edd912236%%MINIFYHTML21c63dccea82234f8d174151624edd912237%
    %MINIFYHTML21c63dccea82234f8d174151624edd912238%%MINIFYHTML21c63dccea82234f8d174151624edd912239%%MINIFYHTML21c63dccea82234f8d174151624edd912240%%MINIFYHTML21c63dccea82234f8d174151624edd912241%%MINIFYHTML21c63dccea82234f8d174151624edd912242%%MINIFYHTML21c63dccea82234f8d174151624edd912243%%MINIFYHTML21c63dccea82234f8d174151624edd912244%%MINIFYHTML21c63dccea82234f8d174151624edd912245%%MINIFYHTML21c63dccea82234f8d174151624edd912246%%MINIFYHTML21c63dccea82234f8d174151624edd912247%%MINIFYHTML21c63dccea82234f8d174151624edd912248%%MINIFYHTML21c63dccea82234f8d174151624edd912249%End%MINIFYHTML21c63dccea82234f8d174151624edd912250%%MINIFYHTML21c63dccea82234f8d174151624edd912251%%MINIFYHTML21c63dccea82234f8d174151624edd912252%%MINIFYHTML21c63dccea82234f8d174151624edd912253%%MINIFYHTML21c63dccea82234f8d174151624edd912254%%MINIFYHTML21c63dccea82234f8d174151624edd912255%%MINIFYHTML21c63dccea82234f8d174151624edd912256%%MINIFYHTML21c63dccea82234f8d174151624edd912257%%MINIFYHTML21c63dccea82234f8d174151624edd912258%%MINIFYHTML21c63dccea82234f8d174151624edd912259%%MINIFYHTML21c63dccea82234f8d174151624edd912260%%MINIFYHTML21c63dccea82234f8d174151624edd912261%%MINIFYHTML21c63dccea82234f8d174151624edd912262%%MINIFYHTML21c63dccea82234f8d174151624edd912263%%MINIFYHTML21c63dccea82234f8d174151624edd912264%%MINIFYHTML21c63dccea82234f8d174151624edd912265%%MINIFYHTML21c63dccea82234f8d174151624edd912266%If%MINIFYHTML21c63dccea82234f8d174151624edd912267%%MINIFYHTML21c63dccea82234f8d174151624edd912268%%MINIFYHTML21c63dccea82234f8d174151624edd912269%%MINIFYHTML21c63dccea82234f8d174151624edd912270%%MINIFYHTML21c63dccea82234f8d174151624edd912271%
    %MINIFYHTML21c63dccea82234f8d174151624edd912272%%MINIFYHTML21c63dccea82234f8d174151624edd912273%%MINIFYHTML21c63dccea82234f8d174151624edd912274%%MINIFYHTML21c63dccea82234f8d174151624edd912275%%MINIFYHTML21c63dccea82234f8d174151624edd912276%%MINIFYHTML21c63dccea82234f8d174151624edd912277%%MINIFYHTML21c63dccea82234f8d174151624edd912278%%MINIFYHTML21c63dccea82234f8d174151624edd912279%%MINIFYHTML21c63dccea82234f8d174151624edd912280%%MINIFYHTML21c63dccea82234f8d174151624edd912281%%MINIFYHTML21c63dccea82234f8d174151624edd912282%%MINIFYHTML21c63dccea82234f8d174151624edd912283%Next%MINIFYHTML21c63dccea82234f8d174151624edd912284%%MINIFYHTML21c63dccea82234f8d174151624edd912285%%MINIFYHTML21c63dccea82234f8d174151624edd912286%%MINIFYHTML21c63dccea82234f8d174151624edd912287%%MINIFYHTML21c63dccea82234f8d174151624edd912288% i
    %MINIFYHTML21c63dccea82234f8d174151624edd912289%%MINIFYHTML21c63dccea82234f8d174151624edd912290%%MINIFYHTML21c63dccea82234f8d174151624edd912291%%MINIFYHTML21c63dccea82234f8d174151624edd912292%%MINIFYHTML21c63dccea82234f8d174151624edd912293%

  4. Simpan worksheet Anda dengan menekan tombol CTRL+S.


Menambahkan Tombol pada Worksheet

  1. Kembali ke worksheet Anda,tambahkan button control menggunakan menu Insert yang terdapat pada tab Developer.

  2. Pada dialog Assign Macro yang muncul. Klik tombol New.
  3. Pada editor yang muncul tambahkan kode berikut padaCourier,monospace;”>Button1_Click().Kembali ke worksheet,klik kanan pada tombol tersebut dan pilih Format Control. Klik tab Properties,dan pilih Don’t move or size with cells. Tekan tombol OK.

  4. Hasil akhir worksheet Anda akan terlihat kira-kira seperti pada screenshot berikut.

  5. Simpan worksheet Anda dengan menekan tombol CTRL+S.

Menjalankan Form Anda

Form Anda sudah selesai dibuat,saatnya kita coba apa yang bisa diperbuat oleh form ini.
  1. Kembali ke worksheet Anda,klik tombol Button 1.
  2. Pada textbox,masukkan teks Coba dan klik tombol Tambah sebanyak 3 kali. Kemudian ganti isi textbox dengan BelajarExcel,dan klik tombol Tambah sebanyak 2 kali. Hasilnya akan terlihat seperti pada screenshot berikut.

  3. Masih dengan entri teks yang sama,coba klik tombol Hapus. Terlihat bahwa baris pertama ditemukannya teks BelajarExcel yaitu baris ke 4 akan dihapus.
  4. Cobalah ubah teks menjadi Coba,klik tombol Hapus sebanyak dua kali. Terlihat bahwa baris pertama dan kedua yang berisi teks Coba akan dihapus.
  5. Selesai.


Memiliki Kesulitan untuk Menyelesaikan Praktek di Atas?

Apabila Anda mengalami kesulitan atau ingin melihat file dan penjelasan yang lebih jauh mengenai kode VBA di atas,silahkan bergabung dengan user group Facebook atau download e-book kami pada alamat berikut:
Semoga Bermanfaat !

BelajarExcel.info

One Comment

  1. bermanfaat…,
    oh ya, kalau gak keberatan bisa tolong buatkan seperti itu tapi isiannya :
    Jenis Produk :
    Nama Benang Rajut :
    Harga :
    Tambahkan, Tutup

    kalau sudah tolong kirimkan ke E-Mail monicha.angelica@gmail.com
    saya sangat membutuhkan sukarela anda, tapi tidak memaksa…, ya
    terima kasih banyak
    sippp

Leave a Reply

Your email address will not be published. Required fields are marked *