Alhamdulillah sudah terpecahkan. Semoga Alloh Swt memberikan imbalan yang besar
dari kasus yang kecil ini. Amin
Terima kasih Mas Suyono
Wa'alaikum salam
Haris
On Thursday, October 16, 2014 9:26 AM, "SUYONO [email protected]
[belajar-excel]" <[email protected]> wrote:
Assalamu'alaikum. Coba seperti ini, semoga membantu. Private Sub
TextBox1_Change() If Len(TextBox1.Text) = TextBox1.MaxLength Then
CommandButton1.SetFocus End If End Sub Wasalam Suyono
From:[email protected] [mailto:[email protected]]
Sent: Thursday, October 16, 2014 8:59 AM
To: [email protected]
Subject: [belajar-excel] Pengkondisian MaxLength pada TextBox
Assalamu'alaikum. Dear para master semua, semoga Alloh Swt selalu menjaga
kesehatandan kemampuan para master, demi orang-orang seperti saya yang
sangatmembutuhkan pencerahan dan solusi atas setiap kasus excel dan VBA yang
sedangdihadapi. Amin Kali ini, sangat mempunyai kasus seperti berikut Saya
ingin mengkondisikan pada TextBox, jika TextBox telah terisi3 digit number maka
setfokus akan langsung beralih pada CommandButton.Bagaimanakah caranya? Saya
sudah mencoba merubah MaxLength pada jendela propertiesTextBox menjadi 3
kemudian saya ketik macro seperti dibawah, tetapi tatkalaTexBox sudah berisi 3
digit number, set fokus tidak berlahi padaCommandButton1. If
TexBox1.MaxLength = true then CommandButton1.SetFocus End If Terima kasih
Salam Haris #yiv7521547932 #yiv7521547932 -- #yiv7521547932ygrp-mkp
{border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0
10px;}#yiv7521547932 #yiv7521547932ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv7521547932 #yiv7521547932ygrp-mkp #yiv7521547932hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7521547932 #yiv7521547932ygrp-mkp #yiv7521547932ads
{margin-bottom:10px;}#yiv7521547932 #yiv7521547932ygrp-mkp .yiv7521547932ad
{padding:0 0;}#yiv7521547932 #yiv7521547932ygrp-mkp .yiv7521547932ad p
{margin:0;}#yiv7521547932 #yiv7521547932ygrp-mkp .yiv7521547932ad a
{color:#0000ff;text-decoration:none;}#yiv7521547932 #yiv7521547932ygrp-sponsor
#yiv7521547932ygrp-lc {font-family:Arial;}#yiv7521547932
#yiv7521547932ygrp-sponsor #yiv7521547932ygrp-lc #yiv7521547932hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7521547932
#yiv7521547932ygrp-sponsor #yiv7521547932ygrp-lc .yiv7521547932ad
{margin-bottom:10px;padding:0 0;}#yiv7521547932 #yiv7521547932actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7521547932
#yiv7521547932activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7521547932
#yiv7521547932activity span {font-weight:700;}#yiv7521547932
#yiv7521547932activity span:first-child
{text-transform:uppercase;}#yiv7521547932 #yiv7521547932activity span a
{color:#5085b6;text-decoration:none;}#yiv7521547932 #yiv7521547932activity span
span {color:#ff7900;}#yiv7521547932 #yiv7521547932activity span
.yiv7521547932underline {text-decoration:underline;}#yiv7521547932
.yiv7521547932attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7521547932 .yiv7521547932attach div a
{text-decoration:none;}#yiv7521547932 .yiv7521547932attach img
{border:none;padding-right:5px;}#yiv7521547932 .yiv7521547932attach label
{display:block;margin-bottom:5px;}#yiv7521547932 .yiv7521547932attach label a
{text-decoration:none;}#yiv7521547932 blockquote {margin:0 0 0
4px;}#yiv7521547932 .yiv7521547932bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7521547932
.yiv7521547932bold a {text-decoration:none;}#yiv7521547932 dd.yiv7521547932last
p a {font-family:Verdana;font-weight:700;}#yiv7521547932 dd.yiv7521547932last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7521547932
dd.yiv7521547932last p span.yiv7521547932yshortcuts
{margin-right:0;}#yiv7521547932 div.yiv7521547932attach-table div div a
{text-decoration:none;}#yiv7521547932 div.yiv7521547932attach-table
{width:400px;}#yiv7521547932 div.yiv7521547932file-title a, #yiv7521547932
div.yiv7521547932file-title a:active, #yiv7521547932
div.yiv7521547932file-title a:hover, #yiv7521547932 div.yiv7521547932file-title
a:visited {text-decoration:none;}#yiv7521547932 div.yiv7521547932photo-title a,
#yiv7521547932 div.yiv7521547932photo-title a:active, #yiv7521547932
div.yiv7521547932photo-title a:hover, #yiv7521547932
div.yiv7521547932photo-title a:visited {text-decoration:none;}#yiv7521547932
div#yiv7521547932ygrp-mlmsg #yiv7521547932ygrp-msg p a
span.yiv7521547932yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7521547932
.yiv7521547932green {color:#628c2a;}#yiv7521547932 .yiv7521547932MsoNormal
{margin:0 0 0 0;}#yiv7521547932 o {font-size:0;}#yiv7521547932
#yiv7521547932photos div {float:left;width:72px;}#yiv7521547932
#yiv7521547932photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7521547932
#yiv7521547932photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7521547932
#yiv7521547932reco-category {font-size:77%;}#yiv7521547932
#yiv7521547932reco-desc {font-size:77%;}#yiv7521547932 .yiv7521547932replbq
{margin:4px;}#yiv7521547932 #yiv7521547932ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7521547932 #yiv7521547932ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7521547932
#yiv7521547932ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7521547932
#yiv7521547932ygrp-mlmsg select, #yiv7521547932 input, #yiv7521547932 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7521547932
#yiv7521547932ygrp-mlmsg pre, #yiv7521547932 code {font:115%
monospace;}#yiv7521547932 #yiv7521547932ygrp-mlmsg *
{line-height:1.22em;}#yiv7521547932 #yiv7521547932ygrp-mlmsg #yiv7521547932logo
{padding-bottom:10px;}#yiv7521547932 #yiv7521547932ygrp-msg p a
{font-family:Verdana;}#yiv7521547932 #yiv7521547932ygrp-msg
p#yiv7521547932attach-count span {color:#1E66AE;font-weight:700;}#yiv7521547932
#yiv7521547932ygrp-reco #yiv7521547932reco-head
{color:#ff7900;font-weight:700;}#yiv7521547932 #yiv7521547932ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7521547932 #yiv7521547932ygrp-sponsor
#yiv7521547932ov li a {font-size:130%;text-decoration:none;}#yiv7521547932
#yiv7521547932ygrp-sponsor #yiv7521547932ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7521547932
#yiv7521547932ygrp-sponsor #yiv7521547932ov ul {margin:0;padding:0 0 0
8px;}#yiv7521547932 #yiv7521547932ygrp-text
{font-family:Georgia;}#yiv7521547932 #yiv7521547932ygrp-text p {margin:0 0 1em
0;}#yiv7521547932 #yiv7521547932ygrp-text tt {font-size:120%;}#yiv7521547932
#yiv7521547932ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7521547932
