Terimakasih Mr.Kid sudah ^^
Pada Kamis, 11 Juni 2015 3:24, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> menulis:
Hai Nisa,
Aktifkan worksheet sebelum proses keluar.
sheets("nama sheet yang akan ditampilkan").activate
unload nama_object_userform
Wassalam,
Kid
2015-06-10 13:39 GMT+10:00 Nisa Khairunnisa [email protected]
[belajar-excel] <[email protected]>:
| Mau tanya lagi, kalau kita buat button exit didalam userform supaya keluar yg
dituju worksheet gmn ya ??
Dikirim dari Yahoo Mail pada Android
| Dari:"Aliif Akbar [email protected] [belajar-excel]"
<[email protected]>
Tanggal:Rab, 10 Jun 2015 pada 7:24
Judul:RE: [belajar-excel] VBA Excel userform
Selamat pagi,
Berarti, userform lain ditutup dulu sebelum form lain muncul bu,
Misal Userform1 dan userform2,
Pada userform1 ada button1,
Saat button1 diklick maka akan muncul userform2, seperti itukah?
Maka di button action klik sebelum ada perintah menampilkan userform2, ditambah
perintah untuk menutup userform1,
Private Sub CommandButton1_Click()
Unload me
Userform2.show
End Sub
Saya sudah mencoba dan berhasil
Sent from Microsoft Outlook for Windows 10 MobileFrom: Nisa Khairunnisa
[email protected] [belajar-excel]
Sent: 10/06/2015 3:09
To: [email protected]
Subject: [belajar-excel] VBA Excel userform
| Ada yang tau gimana caranya supaya yang muncul hanya 1 form, ketika di klik
button menuju ke form lain. Form yg satunya otomatis tertutup. Terimakasih
Dikirim dari Yahoo Mail pada Android |
|
|
#yiv5869246248 #yiv5869246248 -- #yiv5869246248ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5869246248
#yiv5869246248ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5869246248
#yiv5869246248ygrp-mkp #yiv5869246248hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5869246248 #yiv5869246248ygrp-mkp #yiv5869246248ads
{margin-bottom:10px;}#yiv5869246248 #yiv5869246248ygrp-mkp .yiv5869246248ad
{padding:0 0;}#yiv5869246248 #yiv5869246248ygrp-mkp .yiv5869246248ad p
{margin:0;}#yiv5869246248 #yiv5869246248ygrp-mkp .yiv5869246248ad a
{color:#0000ff;text-decoration:none;}#yiv5869246248 #yiv5869246248ygrp-sponsor
#yiv5869246248ygrp-lc {font-family:Arial;}#yiv5869246248
#yiv5869246248ygrp-sponsor #yiv5869246248ygrp-lc #yiv5869246248hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5869246248
#yiv5869246248ygrp-sponsor #yiv5869246248ygrp-lc .yiv5869246248ad
{margin-bottom:10px;padding:0 0;}#yiv5869246248 #yiv5869246248actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5869246248
#yiv5869246248activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5869246248
#yiv5869246248activity span {font-weight:700;}#yiv5869246248
#yiv5869246248activity span:first-child
{text-transform:uppercase;}#yiv5869246248 #yiv5869246248activity span a
{color:#5085b6;text-decoration:none;}#yiv5869246248 #yiv5869246248activity span
span {color:#ff7900;}#yiv5869246248 #yiv5869246248activity span
.yiv5869246248underline {text-decoration:underline;}#yiv5869246248
.yiv5869246248attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5869246248 .yiv5869246248attach div a
{text-decoration:none;}#yiv5869246248 .yiv5869246248attach img
{border:none;padding-right:5px;}#yiv5869246248 .yiv5869246248attach label
{display:block;margin-bottom:5px;}#yiv5869246248 .yiv5869246248attach label a
{text-decoration:none;}#yiv5869246248 blockquote {margin:0 0 0
4px;}#yiv5869246248 .yiv5869246248bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5869246248
.yiv5869246248bold a {text-decoration:none;}#yiv5869246248 dd.yiv5869246248last
p a {font-family:Verdana;font-weight:700;}#yiv5869246248 dd.yiv5869246248last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5869246248
dd.yiv5869246248last p span.yiv5869246248yshortcuts
{margin-right:0;}#yiv5869246248 div.yiv5869246248attach-table div div a
{text-decoration:none;}#yiv5869246248 div.yiv5869246248attach-table
{width:400px;}#yiv5869246248 div.yiv5869246248file-title a, #yiv5869246248
div.yiv5869246248file-title a:active, #yiv5869246248
div.yiv5869246248file-title a:hover, #yiv5869246248 div.yiv5869246248file-title
a:visited {text-decoration:none;}#yiv5869246248 div.yiv5869246248photo-title a,
#yiv5869246248 div.yiv5869246248photo-title a:active, #yiv5869246248
div.yiv5869246248photo-title a:hover, #yiv5869246248
div.yiv5869246248photo-title a:visited {text-decoration:none;}#yiv5869246248
div#yiv5869246248ygrp-mlmsg #yiv5869246248ygrp-msg p a
span.yiv5869246248yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5869246248
.yiv5869246248green {color:#628c2a;}#yiv5869246248 .yiv5869246248MsoNormal
{margin:0 0 0 0;}#yiv5869246248 o {font-size:0;}#yiv5869246248
#yiv5869246248photos div {float:left;width:72px;}#yiv5869246248
#yiv5869246248photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv5869246248
#yiv5869246248photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5869246248
#yiv5869246248reco-category {font-size:77%;}#yiv5869246248
#yiv5869246248reco-desc {font-size:77%;}#yiv5869246248 .yiv5869246248replbq
{margin:4px;}#yiv5869246248 #yiv5869246248ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5869246248 #yiv5869246248ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5869246248
#yiv5869246248ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5869246248
#yiv5869246248ygrp-mlmsg select, #yiv5869246248 input, #yiv5869246248 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5869246248
#yiv5869246248ygrp-mlmsg pre, #yiv5869246248 code {font:115%
monospace;}#yiv5869246248 #yiv5869246248ygrp-mlmsg *
{line-height:1.22em;}#yiv5869246248 #yiv5869246248ygrp-mlmsg #yiv5869246248logo
{padding-bottom:10px;}#yiv5869246248 #yiv5869246248ygrp-msg p a
{font-family:Verdana;}#yiv5869246248 #yiv5869246248ygrp-msg
p#yiv5869246248attach-count span {color:#1E66AE;font-weight:700;}#yiv5869246248
#yiv5869246248ygrp-reco #yiv5869246248reco-head
{color:#ff7900;font-weight:700;}#yiv5869246248 #yiv5869246248ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5869246248 #yiv5869246248ygrp-sponsor
#yiv5869246248ov li a {font-size:130%;text-decoration:none;}#yiv5869246248
#yiv5869246248ygrp-sponsor #yiv5869246248ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5869246248
#yiv5869246248ygrp-sponsor #yiv5869246248ov ul {margin:0;padding:0 0 0
8px;}#yiv5869246248 #yiv5869246248ygrp-text
{font-family:Georgia;}#yiv5869246248 #yiv5869246248ygrp-text p {margin:0 0 1em
0;}#yiv5869246248 #yiv5869246248ygrp-text tt {font-size:120%;}#yiv5869246248
#yiv5869246248ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5869246248
