Ehhh bentar ding, ada 1 lagi yang ingin saya tanyakan.
Adakah Macronya untuk berpindah dari TextBox1 ke CommandButton1 dengan cara
tekan TAB. Artinya dari TextBox saya mau berpindah ke CommandButton dengan cara
tekan tombol TAB. Yang saya alami dari TextBox1 > saya tekan TAB > malah pindah
ke TextBox2, sesuai urutan pada saat saya buat aplikasinya.
Terima kasih
Salam
Haris
On Thursday, October 16, 2014 10:02 AM, ris ha <[email protected]>
wrote:
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 #yiv9969815438 -- #yiv9969815438ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9969815438
#yiv9969815438ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9969815438
#yiv9969815438ygrp-mkp #yiv9969815438hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9969815438 #yiv9969815438ygrp-mkp #yiv9969815438ads
{margin-bottom:10px;}#yiv9969815438 #yiv9969815438ygrp-mkp .yiv9969815438ad
{padding:0 0;}#yiv9969815438 #yiv9969815438ygrp-mkp .yiv9969815438ad p
{margin:0;}#yiv9969815438 #yiv9969815438ygrp-mkp .yiv9969815438ad a
{color:#0000ff;text-decoration:none;}#yiv9969815438 #yiv9969815438ygrp-sponsor
#yiv9969815438ygrp-lc {font-family:Arial;}#yiv9969815438
#yiv9969815438ygrp-sponsor #yiv9969815438ygrp-lc #yiv9969815438hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9969815438
#yiv9969815438ygrp-sponsor #yiv9969815438ygrp-lc .yiv9969815438ad
{margin-bottom:10px;padding:0 0;}#yiv9969815438 #yiv9969815438actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9969815438
#yiv9969815438activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9969815438
#yiv9969815438activity span {font-weight:700;}#yiv9969815438
#yiv9969815438activity span:first-child
{text-transform:uppercase;}#yiv9969815438 #yiv9969815438activity span a
{color:#5085b6;text-decoration:none;}#yiv9969815438 #yiv9969815438activity span
span {color:#ff7900;}#yiv9969815438 #yiv9969815438activity span
.yiv9969815438underline {text-decoration:underline;}#yiv9969815438
.yiv9969815438attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9969815438 .yiv9969815438attach div a
{text-decoration:none;}#yiv9969815438 .yiv9969815438attach img
{border:none;padding-right:5px;}#yiv9969815438 .yiv9969815438attach label
{display:block;margin-bottom:5px;}#yiv9969815438 .yiv9969815438attach label a
{text-decoration:none;}#yiv9969815438 blockquote {margin:0 0 0
4px;}#yiv9969815438 .yiv9969815438bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9969815438
.yiv9969815438bold a {text-decoration:none;}#yiv9969815438 dd.yiv9969815438last
p a {font-family:Verdana;font-weight:700;}#yiv9969815438 dd.yiv9969815438last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9969815438
dd.yiv9969815438last p span.yiv9969815438yshortcuts
{margin-right:0;}#yiv9969815438 div.yiv9969815438attach-table div div a
{text-decoration:none;}#yiv9969815438 div.yiv9969815438attach-table
{width:400px;}#yiv9969815438 div.yiv9969815438file-title a, #yiv9969815438
div.yiv9969815438file-title a:active, #yiv9969815438
div.yiv9969815438file-title a:hover, #yiv9969815438 div.yiv9969815438file-title
a:visited {text-decoration:none;}#yiv9969815438 div.yiv9969815438photo-title a,
#yiv9969815438 div.yiv9969815438photo-title a:active, #yiv9969815438
div.yiv9969815438photo-title a:hover, #yiv9969815438
div.yiv9969815438photo-title a:visited {text-decoration:none;}#yiv9969815438
div#yiv9969815438ygrp-mlmsg #yiv9969815438ygrp-msg p a
span.yiv9969815438yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9969815438
.yiv9969815438green {color:#628c2a;}#yiv9969815438 .yiv9969815438MsoNormal
{margin:0 0 0 0;}#yiv9969815438 o {font-size:0;}#yiv9969815438
#yiv9969815438photos div {float:left;width:72px;}#yiv9969815438
#yiv9969815438photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9969815438
#yiv9969815438photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9969815438
#yiv9969815438reco-category {font-size:77%;}#yiv9969815438
#yiv9969815438reco-desc {font-size:77%;}#yiv9969815438 .yiv9969815438replbq
{margin:4px;}#yiv9969815438 #yiv9969815438ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9969815438 #yiv9969815438ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9969815438
#yiv9969815438ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9969815438
#yiv9969815438ygrp-mlmsg select, #yiv9969815438 input, #yiv9969815438 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9969815438
#yiv9969815438ygrp-mlmsg pre, #yiv9969815438 code {font:115%
monospace;}#yiv9969815438 #yiv9969815438ygrp-mlmsg *
{line-height:1.22em;}#yiv9969815438 #yiv9969815438ygrp-mlmsg #yiv9969815438logo
{padding-bottom:10px;}#yiv9969815438 #yiv9969815438ygrp-msg p a
{font-family:Verdana;}#yiv9969815438 #yiv9969815438ygrp-msg
p#yiv9969815438attach-count span {color:#1E66AE;font-weight:700;}#yiv9969815438
#yiv9969815438ygrp-reco #yiv9969815438reco-head
{color:#ff7900;font-weight:700;}#yiv9969815438 #yiv9969815438ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9969815438 #yiv9969815438ygrp-sponsor
#yiv9969815438ov li a {font-size:130%;text-decoration:none;}#yiv9969815438
#yiv9969815438ygrp-sponsor #yiv9969815438ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9969815438
#yiv9969815438ygrp-sponsor #yiv9969815438ov ul {margin:0;padding:0 0 0
8px;}#yiv9969815438 #yiv9969815438ygrp-text
{font-family:Georgia;}#yiv9969815438 #yiv9969815438ygrp-text p {margin:0 0 1em
0;}#yiv9969815438 #yiv9969815438ygrp-text tt {font-size:120%;}#yiv9969815438
#yiv9969815438ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9969815438
