[belajar-excel] Digest Number 4876

Milis Belajar Microsoft Excel Group

2 Messages

Digest #4876

1a

Re: textbox by "Budi Priyo"

2a

Bls: [belajar-excel] Simulasi penggantian spare part [1 Attachment] by "Marsidi Marsidi"

Messages

1a

Re: textbox

Sun Oct 13, 2019 9:57 pm (PDT) . Posted by:

"Budi Priyo"

Slamat Siang Trima kasih Mas Agus ternyata saya telah menemukannya ternyata
dengan menambah Range("E3").Value = TextBox1 pada awal, dan berhasil.

Private Sub TextBox1_Change()
Range("E3").Value = TextBox1
If Range("E3")..Value <= 700 Then
MsgBox ("LIMIT UKURAN TIDAK SESUAI (700<W>2400)")
TextBox1.SetFocus
End If

If Range("E3").Value >= 2400 Then
MsgBox ("LIMIT UKURAN TIDAK SESUAI (700<W>2400)")
MsgBox "Kekecilen"
TextBox1.SetFocus
End If

Pada tanggal Sen, 14 Okt 2019 pukul 11.21 Agus nangagus@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com> menulis:

>
>
> Letakkan pada tombol validasinya saja, jangan pada textbox change.
> misalnya tombol OK.
> On 10/14/2019 09:39, Budi Priyo monexdani@gmail.com [belajar-excel] wrote:
>
>
> Maaf Mas Agus
> Sudah saya coba tapi baru di ketik satu angka sudah tampil msgbox nya,
> dimana meletakkan codingnya?
> Trima kasih
>
> Pada tanggal Jum, 11 Okt 2019 pukul 21.10 Agus nangagus@gmail.com
> [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
>
>>
>>
>> Dear Mas Budi,
>> bagaimana kalau begini?
>>
>> If TextBox1.Value < 100 Then
>> MsgBox "Kekecilen"
>> TextBox1.SetFocus
>> End If
>> If TextBox1.Value > 500 Then
>> MsgBox "Kebesaren"
>> TextBox1.SetFocus
>>
>> On 10/11/2019 16:39, Budi Priyo monexdani@gmail.com [belajar-excel]
>> wrote:
>>
>>
>> Salam Sejahtera teman2 semua
>> Saya minta tolong bantu permasalah saya.
>> Begini, saya buat textbox di userform yang akan diisi dengan angka tetapi
>> harus ada nilai minimum dan maximum, misalnya minimum 100 dan maximum 500,
>> kalau diluar itu tidak dapat di input.
>> Apakah itu bisa dibuatkan macronya?
>> Mungkin temen2 disini ada yg pernah buat.
>> Trimakasih
>>
>>
>>
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (5) . Top ^

2a

Bls: [belajar-excel] Simulasi penggantian spare part [1 Attachment]

Mon Oct 14, 2019 4:03 am (PDT) . Posted by:

"Marsidi Marsidi"

Sebagai tambahan informasi Jika pada tahun 2019 ada rencana penggantian tetapi belum ada realisasi penggantian maka rencana penggantian di tahun 2020 mengikuti rencana penggantian, tetapi kalau di tahun 2019 sudah ada realisasi penggantian maka rencana penggantian berdasarkan realisasi penggantian. Antara rencana dan realisasi belum tentu di bulan yang sama (sesuai rencana penggantian)

Dikirim dari Yahoo Mail di Android

Pada Min, 13 Okt 2019 pada 13:59, Marsidi MP marsidi.2905@gmail.com [belajar-excel]<belajar-excel@yahoogroups.com> menulis:  

Para master, tolong formula untuk kasus seperti ini #yiv0531014555 #yiv0531014555 -- #yiv0531014555ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0531014555 #yiv0531014555ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0531014555 #yiv0531014555ygrp-mkp #yiv0531014555hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0531014555 #yiv0531014555ygrp-mkp #yiv0531014555ads {margin-bottom:10px;}#yiv0531014555 #yiv0531014555ygrp-mkp .yiv0531014555ad {padding:0 0;}#yiv0531014555 #yiv0531014555ygrp-mkp .yiv0531014555ad p {margin:0;}#yiv0531014555 #yiv0531014555ygrp-mkp .yiv0531014555ad a {color:#0000ff;text-decoration:none;}#yiv0531014555 #yiv0531014555ygrp-sponsor #yiv0531014555ygrp-lc {font-family:Arial;}#yiv0531014555 #yiv0531014555ygrp-sponsor #yiv0531014555ygrp-lc #yiv0531014555hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0531014555 #yiv0531014555ygrp-sponsor #yiv0531014555ygrp-lc .yiv0531014555ad {margin-bottom:10px;padding:0 0;}#yiv0531014555 #yiv0531014555actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0531014555 #yiv0531014555activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0531014555 #yiv0531014555activity span {font-weight:700;}#yiv0531014555 #yiv0531014555activity span:first-child {text-transform:uppercase;}#yiv0531014555 #yiv0531014555activity span a {color:#5085b6;text-decoration:none;}#yiv0531014555 #yiv0531014555activity span span {color:#ff7900;}#yiv0531014555 #yiv0531014555activity span .yiv0531014555underline {text-decoration:underline;}#yiv0531014555 .yiv0531014555attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0531014555 .yiv0531014555attach div a {text-decoration:none;}#yiv0531014555 .yiv0531014555attach img {border:none;padding-right:5px;}#yiv0531014555 .yiv0531014555attach label {display:block;margin-bottom:5px;}#yiv0531014555 .yiv0531014555attach label a {text-decoration:none;}#yiv0531014555 blockquote {margin:0 0 0 4px;}#yiv0531014555 .yiv0531014555bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0531014555 .yiv0531014555bold a {text-decoration:none;}#yiv0531014555 dd.yiv0531014555last p a {font-family:Verdana;font-weight:700;}#yiv0531014555 dd.yiv0531014555last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0531014555 dd.yiv0531014555last p span.yiv0531014555yshortcuts {margin-right:0;}#yiv0531014555 div..yiv0531014555attach-table div div a {text-decoration:none;}#yiv0531014555 div.yiv0531014555attach-table {width:400px;}#yiv0531014555 div.yiv0531014555file-title a, #yiv0531014555 div.yiv0531014555file-title a:active, #yiv0531014555 div.yiv0531014555file-title a:hover, #yiv0531014555 div.yiv0531014555file-title a:visited {text-decoration:none;}#yiv0531014555 div.yiv0531014555photo-title a, #yiv0531014555 div.yiv0531014555photo-title a:active, #yiv0531014555 div.yiv0531014555photo-title a:hover, #yiv0531014555 div.yiv0531014555photo-title a:visited {text-decoration:none;}#yiv0531014555 div#yiv0531014555ygrp-mlmsg #yiv0531014555ygrp-msg p a span.yiv0531014555yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0531014555 .yiv0531014555green {color:#628c2a;}#yiv0531014555 .yiv0531014555MsoNormal {margin:0 0 0 0;}#yiv0531014555 o {font-size:0;}#yiv0531014555 #yiv0531014555photos div {float:left;width:72px;}#yiv0531014555 #yiv0531014555photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0531014555 #yiv0531014555photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0531014555 #yiv0531014555reco-category {font-size:77%;}#yiv0531014555 #yiv0531014555reco-desc {font-size:77%;}#yiv0531014555 .yiv0531014555replbq {margin:4px;}#yiv0531014555 #yiv0531014555ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0531014555 #yiv0531014555ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0531014555 #yiv0531014555ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0531014555 #yiv0531014555ygrp-mlmsg select, #yiv0531014555 input, #yiv0531014555 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0531014555 #yiv0531014555ygrp-mlmsg pre, #yiv0531014555 code {font:115% monospace;}#yiv0531014555 #yiv0531014555ygrp-mlmsg * {line-height:1.22em;}#yiv0531014555 #yiv0531014555ygrp-mlmsg #yiv0531014555logo {padding-bottom:10px;}#yiv0531014555 #yiv0531014555ygrp-msg p a {font-family:Verdana;}#yiv0531014555 #yiv0531014555ygrp-msg p#yiv0531014555attach-count span {color:#1E66AE;font-weight:700;}#yiv0531014555 #yiv0531014555ygrp-reco #yiv0531014555reco-head {color:#ff7900;font-weight:700;}#yiv0531014555 #yiv0531014555ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0531014555 #yiv0531014555ygrp-sponsor #yiv0531014555ov li a {font-size:130%;text-decoration:none;}#yiv0531014555 #yiv0531014555ygrp-sponsor #yiv0531014555ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0531014555 #yiv0531014555ygrp-sponsor #yiv0531014555ov ul {margin:0;padding:0 0 0 8px;}#yiv0531014555 #yiv0531014555ygrp-text {font-family:Georgia;}#yiv0531014555 #yiv0531014555ygrp-text p {margin:0 0 1em 0;}#yiv0531014555 #yiv0531014555ygrp-text tt {font-size:120%;}#yiv0531014555 #yiv0531014555ygrp-vital ul li:last-child {border-right:none !important;}#yiv0531014555

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Visit Your Group

• Privacy • Unsubscribe • Terms of Use