Dear Mr. Kid,
Terima kasih atas pencerahannya.Mengenai Regional Setting sudah sy kondisikan
dengan format English (United States), namun hasil kalkulasinya masih salah
(sebagai mana lampiran sebelumnya).
Tetapi jika dikondisikan dengan format Indonesian (Indonesia), justru makin
error.Sebagai info tambahan, pada PC dimaksud juga ada program yang registered
yang format tanggalnya adalah : dd/MM/yyyy.
Jika format tanggalnya sy ganti dengan MM/dd/yyyy, maka program yang registered
tersebut yang menjadi error.
Mohon pencerahannya.
Terima kasih & Wassalamu'alaikum Wr. Wb.
Pada Selasa, 7 Februari 2017 11:37, "'Mr. Kid' mr.nm...@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
wa'alaikumussalam wr wb
Hai Harry,
Jika Anda menggunakan VBA, JANGAN pernah mengabaikan regional setting komputer
user yang akan menggunakannya. Setiap script yang berhubungan dengan format
number maupun date HARUS memperhatikan hal ini.
Wassalamu'alaikum wr wb
Kid
2017-02-06 11:47 GMT+07:00 Harry hariansyah...@yahoo.com [belajar-excel]
<belajar-excel@yahoogroups.com>:
Dear Be-Exceller,
Assalamu'alaikum Wr. Wb.
Sy mengoperasikan Workbook yang telah sy buat di Windows 7 64 bit. Namun jika
Workbook tersebut sy gunakan pada Windows 32 bit, hasil Kalkulasi pada User
Form-nya beda.
Apakah kesalahannya pada Windownya atau ada sesuatu yang belum sy
mengerti.Terlampir User Form yang hasilnya beda.
Mohon informasi dan pencerahan dari sahabat-sahabat Be-Exceller sekalian.
Terima kasih & Wassalam...
#yiv4198998587 -- #yiv4198998587ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4198998587
#yiv4198998587ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4198998587
#yiv4198998587ygrp-mkp #yiv4198998587hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4198998587 #yiv4198998587ygrp-mkp #yiv4198998587ads
{margin-bottom:10px;}#yiv4198998587 #yiv4198998587ygrp-mkp .yiv4198998587ad
{padding:0 0;}#yiv4198998587 #yiv4198998587ygrp-mkp .yiv4198998587ad p
{margin:0;}#yiv4198998587 #yiv4198998587ygrp-mkp .yiv4198998587ad a
{color:#0000ff;text-decoration:none;}#yiv4198998587 #yiv4198998587ygrp-sponsor
#yiv4198998587ygrp-lc {font-family:Arial;}#yiv4198998587
#yiv4198998587ygrp-sponsor #yiv4198998587ygrp-lc #yiv4198998587hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4198998587
#yiv4198998587ygrp-sponsor #yiv4198998587ygrp-lc .yiv4198998587ad
{margin-bottom:10px;padding:0 0;}#yiv4198998587 #yiv4198998587actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4198998587
#yiv4198998587activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4198998587
#yiv4198998587activity span {font-weight:700;}#yiv4198998587
#yiv4198998587activity span:first-child
{text-transform:uppercase;}#yiv4198998587 #yiv4198998587activity span a
{color:#5085b6;text-decoration:none;}#yiv4198998587 #yiv4198998587activity span
span {color:#ff7900;}#yiv4198998587 #yiv4198998587activity span
.yiv4198998587underline {text-decoration:underline;}#yiv4198998587
.yiv4198998587attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4198998587 .yiv4198998587attach div a
{text-decoration:none;}#yiv4198998587 .yiv4198998587attach img
{border:none;padding-right:5px;}#yiv4198998587 .yiv4198998587attach label
{display:block;margin-bottom:5px;}#yiv4198998587 .yiv4198998587attach label a
{text-decoration:none;}#yiv4198998587 blockquote {margin:0 0 0
4px;}#yiv4198998587 .yiv4198998587bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4198998587
.yiv4198998587bold a {text-decoration:none;}#yiv4198998587 dd.yiv4198998587last
p a {font-family:Verdana;font-weight:700;}#yiv4198998587 dd.yiv4198998587last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4198998587
dd.yiv4198998587last p span.yiv4198998587yshortcuts
{margin-right:0;}#yiv4198998587 div.yiv4198998587attach-table div div a
{text-decoration:none;}#yiv4198998587 div.yiv4198998587attach-table
{width:400px;}#yiv4198998587 div.yiv4198998587file-title a, #yiv4198998587
div.yiv4198998587file-title a:active, #yiv4198998587
div.yiv4198998587file-title a:hover, #yiv4198998587 div.yiv4198998587file-title
a:visited {text-decoration:none;}#yiv4198998587 div.yiv4198998587photo-title a,
#yiv4198998587 div.yiv4198998587photo-title a:active, #yiv4198998587
div.yiv4198998587photo-title a:hover, #yiv4198998587
div.yiv4198998587photo-title a:visited {text-decoration:none;}#yiv4198998587
div#yiv4198998587ygrp-mlmsg #yiv4198998587ygrp-msg p a
span.yiv4198998587yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4198998587
.yiv4198998587green {color:#628c2a;}#yiv4198998587 .yiv4198998587MsoNormal
{margin:0 0 0 0;}#yiv4198998587 o {font-size:0;}#yiv4198998587
#yiv4198998587photos div {float:left;width:72px;}#yiv4198998587
#yiv4198998587photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4198998587
#yiv4198998587photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4198998587
#yiv4198998587reco-category {font-size:77%;}#yiv4198998587
#yiv4198998587reco-desc {font-size:77%;}#yiv4198998587 .yiv4198998587replbq
{margin:4px;}#yiv4198998587 #yiv4198998587ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4198998587 #yiv4198998587ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4198998587
#yiv4198998587ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4198998587
#yiv4198998587ygrp-mlmsg select, #yiv4198998587 input, #yiv4198998587 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4198998587
#yiv4198998587ygrp-mlmsg pre, #yiv4198998587 code {font:115%
monospace;}#yiv4198998587 #yiv4198998587ygrp-mlmsg *
{line-height:1.22em;}#yiv4198998587 #yiv4198998587ygrp-mlmsg #yiv4198998587logo
{padding-bottom:10px;}#yiv4198998587 #yiv4198998587ygrp-msg p a
{font-family:Verdana;}#yiv4198998587 #yiv4198998587ygrp-msg
p#yiv4198998587attach-count span {color:#1E66AE;font-weight:700;}#yiv4198998587
#yiv4198998587ygrp-reco #yiv4198998587reco-head
{color:#ff7900;font-weight:700;}#yiv4198998587 #yiv4198998587ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4198998587 #yiv4198998587ygrp-sponsor
#yiv4198998587ov li a {font-size:130%;text-decoration:none;}#yiv4198998587
#yiv4198998587ygrp-sponsor #yiv4198998587ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4198998587
#yiv4198998587ygrp-sponsor #yiv4198998587ov ul {margin:0;padding:0 0 0
8px;}#yiv4198998587 #yiv4198998587ygrp-text
{font-family:Georgia;}#yiv4198998587 #yiv4198998587ygrp-text p {margin:0 0 1em
0;}#yiv4198998587 #yiv4198998587ygrp-text tt {font-size:120%;}#yiv4198998587
#yiv4198998587ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4198998587
