Kamis, 25 September 2014

[belajar-excel] Digest Number 3108

2 Messages

Digest #3108

Messages

Thu Sep 25, 2014 2:06 am (PDT) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Mas Zain,

coba pakai xltop saja daripada xledgetop

Wassalam,
Kid.

2014-09-25 17:30 GMT+10:00 'zainul_ulum[at]yahoo[dot]com'
zainul_ulum@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>:

>
>
> Be-Excelers,
> Saya membuat object FormatCondition bernama fmtCondPlan.
> FormatCondition saya atur formula dan stylenya sbb:
> (complete code vba ada di file terlampir)
>
>
> '=================================================================================================
> Set fmtCondPlan = rgData.FormatConditions.Add(Type:=xlExpression,
> Formula1:="=" & strCondPlan)
> With fmtCondPlan
> .Interior.Color = rgbAquamarine
> .Borders.LineStyle = xlContinuous 'note #1
> '.Borders(xlEdgeTop).LineStyle = xlContinuous 'note #2
> End With
>
> '==================================================================================================
>
> Saat baris note#2 saya non-active kan, program berjalan dengan baik,
> tetapi jika note#1 saya non activekan dan note#2 saya aktifkan muncul pesan
> error "Unable to set the LineStyle property of the Border class".
>
> Hasil yang diharapkan adalah pada baris Rencana: Ada garis continuos di
> atas, sedangkan pada baris Aktual: ada garis putus-putus.
>
> Mohon pencerahan solusinya.
>
> terimakasih
> -zainul
>
>
>

Thu Sep 25, 2014 2:35 am (PDT) . Posted by:

"zainul_ulum[at]yahoo[dot]com" zainul_ulum

Terimakasih Mas Kid,
Behasil !!!

Wassalam
-zainul

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: Thursday, September 25, 2014 4:06 PM
To: BeExcel
Subject: Re: [belajar-excel] Error: "Unable to set the LineStyle property of the Border class" saat setting conditional format lewat VBA

Mas Zain,
coba pakai xltop saja daripada xledgetop
Wassalam,
Kid.

2014-09-25 17:30 GMT+10:00 'zainul_ulum[at]yahoo[dot]com' zainul_ulum@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>:

Be-Excelers,
Saya membuat object FormatCondition bernama fmtCondPlan.
FormatCondition saya atur formula dan stylenya sbb:
(complete code vba ada di file terlampir)

'=================================================================================================
Set fmtCondPlan = rgData.FormatConditions.Add(Type:=xlExpression, Formula1:="=" & strCondPlan)
With fmtCondPlan
.Interior.Color = rgbAquamarine
.Borders.LineStyle = xlContinuous 'note #1
'.Borders(xlEdgeTop).LineStyle = xlContinuous 'note #2
End With
'==================================================================================================

Saat baris note#2 saya non-active kan, program berjalan dengan baik, tetapi jika note#1 saya non activekan dan note#2 saya aktifkan muncul pesan error "Unable to set the LineStyle property of the Border class".

Hasil yang diharapkan adalah pada baris Rencana: Ada garis continuos di atas, sedangkan pada baris Aktual: ada garis putus-putus.

Mohon pencerahan solusinya.

terimakasih
-zainul

============================================================
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
---------------------------------------------------------------------

Tidak ada komentar:

Posting Komentar