Dear Prasaja,
Pernah dengar kata Deklarasi...Cobalah gunakan Deklarasi sesuai dengan
kebutuhan yang anda inginkan....
TerimaKasih.
Pada Selasa, 7 Juni 2016 15:13, "[email protected] [belajar-excel]"
<[email protected]> menulis:
Asslamu'alaikum para master,
mohon maaf menggangu puasa nya bagi yang menjalankan hehe
saya mau tanya, bagaimana mengoperasikan perhitungan dalam VBA dengan variable
yang mengandung bilangan desimal ?
contoh : saya punya rumus
Range("A1").formula = "=2+" & D
jika nilai D bernilai desimal error terus, saya dah coba2 tetap saja eror, tp
jika bukan bilangan desimal bisa berjalan dengan baik.
jika formula dalam VBA saya rubah jadi :
Range("A1"). Formula = 2 + D
(anggaplah nilai D=2.3)
memang ini bisa, tapi hasil yang tertera di "formula bar" hanya hasilnya yaitu
"4.3" bukan "=2+2.3"
jadi tujuan yang ingin dicapai adalah
1.Dalam VBA
2.Memakai perhitungan dengan variable yang berisi bilangan desimal
3.Hasilnya di formula bar berupa formula nya, bukan hasilnya
Jika penjelasan saya kurang jelas, bisa diliat di file excel yang saya attatch,
Terima kasih sebelumnya para master
Wasslamu'alaikum #yiv8638250260 #yiv8638250260 -- #yiv8638250260ygrp-mkp
{border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0
10px;}#yiv8638250260 #yiv8638250260ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv8638250260 #yiv8638250260ygrp-mkp #yiv8638250260hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8638250260 #yiv8638250260ygrp-mkp #yiv8638250260ads
{margin-bottom:10px;}#yiv8638250260 #yiv8638250260ygrp-mkp .yiv8638250260ad
{padding:0 0;}#yiv8638250260 #yiv8638250260ygrp-mkp .yiv8638250260ad p
{margin:0;}#yiv8638250260 #yiv8638250260ygrp-mkp .yiv8638250260ad a
{color:#0000ff;text-decoration:none;}#yiv8638250260 #yiv8638250260ygrp-sponsor
#yiv8638250260ygrp-lc {font-family:Arial;}#yiv8638250260
#yiv8638250260ygrp-sponsor #yiv8638250260ygrp-lc #yiv8638250260hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8638250260
#yiv8638250260ygrp-sponsor #yiv8638250260ygrp-lc .yiv8638250260ad
{margin-bottom:10px;padding:0 0;}#yiv8638250260 #yiv8638250260actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8638250260
#yiv8638250260activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8638250260
#yiv8638250260activity span {font-weight:700;}#yiv8638250260
#yiv8638250260activity span:first-child
{text-transform:uppercase;}#yiv8638250260 #yiv8638250260activity span a
{color:#5085b6;text-decoration:none;}#yiv8638250260 #yiv8638250260activity span
span {color:#ff7900;}#yiv8638250260 #yiv8638250260activity span
.yiv8638250260underline {text-decoration:underline;}#yiv8638250260
.yiv8638250260attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;min-width:400px;}#yiv8638250260 .yiv8638250260attach div a
{text-decoration:none;}#yiv8638250260 .yiv8638250260attach img
{border:none;padding-right:5px;}#yiv8638250260 .yiv8638250260attach label
{display:block;margin-bottom:5px;}#yiv8638250260 .yiv8638250260attach label a
{text-decoration:none;}#yiv8638250260 blockquote {margin:0 0 0
4px;}#yiv8638250260 .yiv8638250260bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8638250260
.yiv8638250260bold a {text-decoration:none;}#yiv8638250260 dd.yiv8638250260last
p a {font-family:Verdana;font-weight:700;}#yiv8638250260 dd.yiv8638250260last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8638250260
dd.yiv8638250260last p span.yiv8638250260yshortcuts
{margin-right:0;}#yiv8638250260 div.yiv8638250260attach-table div div a
{text-decoration:none;}#yiv8638250260 div.yiv8638250260attach-table
{min-width:400px;}#yiv8638250260 div.yiv8638250260file-title a, #yiv8638250260
div.yiv8638250260file-title a:active, #yiv8638250260
div.yiv8638250260file-title a:hover, #yiv8638250260 div.yiv8638250260file-title
a:visited {text-decoration:none;}#yiv8638250260 div.yiv8638250260photo-title a,
#yiv8638250260 div.yiv8638250260photo-title a:active, #yiv8638250260
div.yiv8638250260photo-title a:hover, #yiv8638250260
div.yiv8638250260photo-title a:visited {text-decoration:none;}#yiv8638250260
div#yiv8638250260ygrp-mlmsg #yiv8638250260ygrp-msg p a
span.yiv8638250260yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8638250260
.yiv8638250260green {color:#628c2a;}#yiv8638250260 .yiv8638250260MsoNormal
{margin:0 0 0 0;}#yiv8638250260 o {font-size:0;}#yiv8638250260
#yiv8638250260photos div {float:left;min-width:72px;}#yiv8638250260
#yiv8638250260photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;min-width:62px;}#yiv8638250260
#yiv8638250260photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;min-width:64px;}#yiv8638250260
#yiv8638250260reco-category {font-size:77%;}#yiv8638250260
#yiv8638250260reco-desc {font-size:77%;}#yiv8638250260 .yiv8638250260replbq
{margin:4px;}#yiv8638250260 #yiv8638250260ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8638250260 #yiv8638250260ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8638250260
#yiv8638250260ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8638250260
#yiv8638250260ygrp-mlmsg select, #yiv8638250260 input, #yiv8638250260 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8638250260
#yiv8638250260ygrp-mlmsg pre, #yiv8638250260 code {font:115%
monospace;}#yiv8638250260 #yiv8638250260ygrp-mlmsg *
{line-height:1.22em;}#yiv8638250260 #yiv8638250260ygrp-mlmsg #yiv8638250260logo
{padding-bottom:10px;}#yiv8638250260 #yiv8638250260ygrp-msg p a
{font-family:Verdana;}#yiv8638250260 #yiv8638250260ygrp-msg
p#yiv8638250260attach-count span {color:#1E66AE;font-weight:700;}#yiv8638250260
#yiv8638250260ygrp-reco #yiv8638250260reco-head
{color:#ff7900;font-weight:700;}#yiv8638250260 #yiv8638250260ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8638250260 #yiv8638250260ygrp-sponsor
#yiv8638250260ov li a {font-size:130%;text-decoration:none;}#yiv8638250260
#yiv8638250260ygrp-sponsor #yiv8638250260ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8638250260
#yiv8638250260ygrp-sponsor #yiv8638250260ov ul {margin:0;padding:0 0 0
8px;}#yiv8638250260 #yiv8638250260ygrp-text
{font-family:Georgia;}#yiv8638250260 #yiv8638250260ygrp-text p {margin:0 0 1em
0;}#yiv8638250260 #yiv8638250260ygrp-text tt {font-size:120%;}#yiv8638250260
#yiv8638250260ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8638250260
