* 25 Juli 2011 15:18
>
> *To:* belajar-excel@yahoogroups.com
> *Subject:* Re: [belajar-excel] ctv_ListBox Multi_Kolom.xls
>
> ** **
>
>
>
> Apakah harus pakai userform ?
> Bukankah sheet dengan proteksi sheet sudah bisa membantu ?
> Oh mungkin selera saja.
t;
> Regards
>
> RidwanRahman
>
> ** **
>
> *From:* belajar-excel@yahoogroups.com [mailto:
> belajar-excel@yahoogroups.com] *On Behalf Of *Mr. Kid
> *Sent:* 25 Juli 2011 15:18
>
> *To:* belajar-excel@yahoogroups.com
> *Subject:* Re: [belajar-excel] ctv_Lis
data banyak yg seram-seram itu.
Regards
RidwanRahman
From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
On Behalf Of Mr. Kid
Sent: 25 Juli 2011 15:18
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] ctv_ListBox Multi_Kolom.xls
Apakah harus pakai
; RidwanRahman
>
> ** **
>
> *From:* belajar-excel@yahoogroups.com [mailto:
> belajar-excel@yahoogroups.com] *On Behalf Of *STDEV(i)
> *Sent:* 25 Juli 2011 13:51
> *To:* belajar-excel@yahoogroups.com
> *Subject:* Re: [belajar-excel] ctv_ListBox Multi_Kolom.xls
>
> ** **
&
date-nya Indonesia
Salam
RidwanRahman
From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com] On
Behalf Of STDEV(i)
Sent: 25 Juli 2011 13:51
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] ctv_ListBox Multi_Kolom.xls
Private Sub UserForm_Initialize
Private Sub UserForm_Initialize()
' siti Vi // 21 Juli 2011
' rev2: 25 jul 2011
'
Dim Cabang As Range, UniqCab, UniqTgl, UniqPjb, n As Long
Set Tbl = Sheets("Sheet1").Cells(4, 3).CurrentRegion
Set Cabang = Tbl.Offset(2, 2).Resize(Tbl.Rows.Count - 2, 1)
6 matches
Mail list logo