Re: [belajar-excel] Menuju sheet tertentu

[hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]]

Kalau hanya ingin menuju sheet tertentu tanpa combobox barangkali bisa gunakan
Sub Displ_Sheets()    ' to display sheets press Ctrl Shift D    
Application.CommandBars("Workbook Tabs").ShowPopupEnd Sub
Salam,HK
nb : sumber internet
      From: "Danny Prasetyo danny_06...@yahoo.com [belajar-excel]" 
<belajar-excel@yahoogroups.com>
 To: belajar-excel@yahoogroups.com 
 Sent: Friday, 27 March 2015, 11:22
 Subject: [belajar-excel] Menuju sheet tertentu
   
     ‎Saya mempunyai combobox di dalam userform yang berisi seluruh sheet dalam 
workbook. Dan saya ingin menuju sheet yang dipilih dalam combobox tersebut. 
Jadi setelah kita memilih sheet di combobox, dengan otomatis kita langsung 
berpindah sheet. Lalu kode VBA apa yang digunakan?   #yiv6994307035 
#yiv6994307035 -- #yiv6994307035ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6994307035 
#yiv6994307035ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6994307035 
#yiv6994307035ygrp-mkp #yiv6994307035hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv6994307035 #yiv6994307035ygrp-mkp #yiv6994307035ads 
{margin-bottom:10px;}#yiv6994307035 #yiv6994307035ygrp-mkp .yiv6994307035ad 
{padding:0 0;}#yiv6994307035 #yiv6994307035ygrp-mkp .yiv6994307035ad p 
{margin:0;}#yiv6994307035 #yiv6994307035ygrp-mkp .yiv6994307035ad a 
{color:#0000ff;text-decoration:none;}#yiv6994307035 #yiv6994307035ygrp-sponsor 
#yiv6994307035ygrp-lc {font-family:Arial;}#yiv6994307035 
#yiv6994307035ygrp-sponsor #yiv6994307035ygrp-lc #yiv6994307035hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6994307035 
#yiv6994307035ygrp-sponsor #yiv6994307035ygrp-lc .yiv6994307035ad 
{margin-bottom:10px;padding:0 0;}#yiv6994307035 #yiv6994307035actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6994307035 
#yiv6994307035activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6994307035
 #yiv6994307035activity span {font-weight:700;}#yiv6994307035 
#yiv6994307035activity span:first-child 
{text-transform:uppercase;}#yiv6994307035 #yiv6994307035activity span a 
{color:#5085b6;text-decoration:none;}#yiv6994307035 #yiv6994307035activity span 
span {color:#ff7900;}#yiv6994307035 #yiv6994307035activity span 
.yiv6994307035underline {text-decoration:underline;}#yiv6994307035 
.yiv6994307035attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv6994307035 .yiv6994307035attach div a 
{text-decoration:none;}#yiv6994307035 .yiv6994307035attach img 
{border:none;padding-right:5px;}#yiv6994307035 .yiv6994307035attach label 
{display:block;margin-bottom:5px;}#yiv6994307035 .yiv6994307035attach label a 
{text-decoration:none;}#yiv6994307035 blockquote {margin:0 0 0 
4px;}#yiv6994307035 .yiv6994307035bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6994307035 
.yiv6994307035bold a {text-decoration:none;}#yiv6994307035 dd.yiv6994307035last 
p a {font-family:Verdana;font-weight:700;}#yiv6994307035 dd.yiv6994307035last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6994307035 
dd.yiv6994307035last p span.yiv6994307035yshortcuts 
{margin-right:0;}#yiv6994307035 div.yiv6994307035attach-table div div a 
{text-decoration:none;}#yiv6994307035 div.yiv6994307035attach-table 
{width:400px;}#yiv6994307035 div.yiv6994307035file-title a, #yiv6994307035 
div.yiv6994307035file-title a:active, #yiv6994307035 
div.yiv6994307035file-title a:hover, #yiv6994307035 div.yiv6994307035file-title 
a:visited {text-decoration:none;}#yiv6994307035 div.yiv6994307035photo-title a, 
#yiv6994307035 div.yiv6994307035photo-title a:active, #yiv6994307035 
div.yiv6994307035photo-title a:hover, #yiv6994307035 
div.yiv6994307035photo-title a:visited {text-decoration:none;}#yiv6994307035 
div#yiv6994307035ygrp-mlmsg #yiv6994307035ygrp-msg p a 
span.yiv6994307035yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6994307035 
.yiv6994307035green {color:#628c2a;}#yiv6994307035 .yiv6994307035MsoNormal 
{margin:0 0 0 0;}#yiv6994307035 o {font-size:0;}#yiv6994307035 
#yiv6994307035photos div {float:left;width:72px;}#yiv6994307035 
#yiv6994307035photos div div {border:1px solid 
#666666;height:62px;overflow:hidden;width:62px;}#yiv6994307035 
#yiv6994307035photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6994307035
 #yiv6994307035reco-category {font-size:77%;}#yiv6994307035 
#yiv6994307035reco-desc {font-size:77%;}#yiv6994307035 .yiv6994307035replbq 
{margin:4px;}#yiv6994307035 #yiv6994307035ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv6994307035 #yiv6994307035ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6994307035 
#yiv6994307035ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6994307035 
#yiv6994307035ygrp-mlmsg select, #yiv6994307035 input, #yiv6994307035 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6994307035 
#yiv6994307035ygrp-mlmsg pre, #yiv6994307035 code {font:115% 
monospace;}#yiv6994307035 #yiv6994307035ygrp-mlmsg * 
{line-height:1.22em;}#yiv6994307035 #yiv6994307035ygrp-mlmsg #yiv6994307035logo 
{padding-bottom:10px;}#yiv6994307035 #yiv6994307035ygrp-msg p a 
{font-family:Verdana;}#yiv6994307035 #yiv6994307035ygrp-msg 
p#yiv6994307035attach-count span {color:#1E66AE;font-weight:700;}#yiv6994307035 
#yiv6994307035ygrp-reco #yiv6994307035reco-head 
{color:#ff7900;font-weight:700;}#yiv6994307035 #yiv6994307035ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv6994307035 #yiv6994307035ygrp-sponsor 
#yiv6994307035ov li a {font-size:130%;text-decoration:none;}#yiv6994307035 
#yiv6994307035ygrp-sponsor #yiv6994307035ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6994307035 
#yiv6994307035ygrp-sponsor #yiv6994307035ov ul {margin:0;padding:0 0 0 
8px;}#yiv6994307035 #yiv6994307035ygrp-text 
{font-family:Georgia;}#yiv6994307035 #yiv6994307035ygrp-text p {margin:0 0 1em 
0;}#yiv6994307035 #yiv6994307035ygrp-text tt {font-size:120%;}#yiv6994307035 
#yiv6994307035ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv6994307035