Messages In This Digest (4 Messages)

1.: Invitation to connect on LinkedIn From: suryana sakti

2a.: Re: Validation bersyarat validasi sebelumnya From: STDEV(i)

3a.: Combine Formulas but Result is Different From: Fano The Miner
3b.: Re: Combine Formulas but Result is Different From: Kid Mr.

View All Topics | Create New Topic

Messages

1.: Invitation to connect on LinkedIn

Posted by: "suryana sakti" sakti_suryana@yahoo.co.id sakti_suryana

Sat Sep 24, 2011 3:31 pm (PDT)

I'd like to add you to my professional network on LinkedIn.

- suryana

suryana sakti
Student at STITEK Bontang
Indonesia

Confirm that you know suryana sakti:
https://www.linkedin.com/e/-d00nws-gsz6ca3x-24/isd/4337530701/WvuGHHxm/?hs=false&tok=0MMpwrEIzDVQU1

--
You are receiving Invitation to Connect emails. Click to unsubscribe:
http://www.linkedin.com/e/-d00nws-gsz6ca3x-24/aqk5fQ3JiWTKVtq8ZmJ-MkIjMAo0aEBUZ4Js-F5BItM0/goo/belajar-excel%40yahoogroups%2Ecom/20061/I1501622708_1/?hs=false&tok=3hVvYa5brDVQU1

(c) 2011 LinkedIn Corporation. 2029 Stierlin Ct, Mountain View, CA 94043, USA.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)

2a.: Re: Validation bersyarat validasi sebelumnya

Posted by: "STDEV(i)" setiyowati.devi@gmail.com siti_vi

Sat Sep 24, 2011 8:25 pm (PDT)

Kalau ingin pakai ComboBox di dalam UserForm...
Data pada Tabel Referensi dapat di tambah (records-nya) dan macro akan
mengikuti
/menyesuaikan isi tiap komboboxnya...

[image: combobox validasi.PNG]

'-------------------------------------------
' coded by: siti Vi / Bintaro / 24 sep 2011
'-------------------------------------------
Dim ArProd As Variant, sUniq As String
Dim Tbl As Range, i As Long, tRows As Long

Private Sub *UserForm_Initialize*()
' mengenali tabel referensi
Set Tbl = Sheets("Sheet2").Cells(4, 2).CurrentRegion.Offset(1, 0)
tRows = Tbl.Rows.Count - 1

' mengisi list pada KomboProduk
sUniq = "|"
For i = 1 To tRows
' mengambil UniqValues -nya, dgn cara primitif..
If InStr(1, sUniq, "|" & Tbl(i, 1) & "|") = 0 Then
sUniq = sUniq & Tbl(i, 1) & "|"
CboProduk.AddItem Tbl(i, 1)
End If
Next i
CboProduk.SetFocus
End Sub

Private Sub *CboProduk_Change*()
CboVarian.Clear
With CboMereks
.Clear
sUniq = "|"
For i = 1 To tRows
'--Jika Kolom Produk = KomboProduk, maka....
If Tbl(i, 1) = CboProduk.Value Then
' KomboMerek hanya diisi dgn data Uniq saja
If InStr(1, sUniq, "|" & Tbl(i, 2) & "|") = 0 Then
sUniq = sUniq & Tbl(i, 2) & "|"
.AddItem Tbl(i, 2)
End If
End If
Next
.SetFocus
' jika untuk Merk tertentu Varian-nya hanya SATU, langsung di
tayangkan
If .ListCount = 1 Then .ListIndex = 0
End With
End Sub

Private Sub *CboMereks_Change*()

With CboVarian
.Clear
sUniq = "|"
For i = 1 To tRows
'--Jika dua Kolom pertama = dua KomboBox pertama, maka...
If Tbl(i, 1) = CboProduk.Value Then
If Tbl(i, 2) = CboMereks.Value Then
' KomboVarian hanya diisi dgn data Uniq saja
If InStr(1, sUniq, "|" & Tbl(i, 3) & "|") = 0 Then
sUniq = sUniq & Tbl(i, 3) & "|"
.AddItem Tbl(i, 3)
End If
End If
End If
Next
.SetFocus
If .ListCount = 1 Then .ListIndex = 0
End With
End Sub

Private Sub CmdClear_Click()
CboProduk.ListIndex = -1
CboMereks.ListIndex = -1
CboVarian.ListIndex = -1
End Sub

Private Sub CmdClose_Click()
Unload Me
End Sub

lihat kasus yg sama tahun 2009
http://tech.groups.yahoo.com/group/XL-mania/message/12483

~siti
The DO and The DONT's ......
http://www.box.net/shared/2mbjr3g654k1ubiomijq

2011/9/24 Wildan Fauzi <wildanfauzy@gmail.com>

> **
>
> Trims mbak Siti.... menambah wawasan saya untuk memaksimalkan fungsi excel.
> Pakai makro boleh juga tuh mbak,
> Tapi dikasih keterangan ya.... seperti kalo mbak siti jawab pertanyaan
> lain.... :D
> Mantab Surantab
> Top Markotop
> Jos Gandhos
> Buat Mr Kid n Mbak Siti. Sukses selalu
>
> Salam
> Wildan Fauzi
>
> 2011/9/24 STDEV(i) <setiyowati.devi@gmail.com>
>
>> validasi merk
>> =OFFSET(C3,MATCH(M18,B4:B22,0),0,COUNTIF(B4:B22,M18),1)
>>
>> validasi variant:
>> =OFFSET(D3,MATCH(N18,C4:C22,0),0,COUNTIF(C4:C22,N18),1)
>>
>> dummies hanya 1 tabel kecil (unique-values untuk Products)
>> sayangnya validasi merk masih dobel (sesuai varian yg ada)
>> walaupun sudah dieiminasi khusus untuk merk PRODUCT yg sedang
>> dipilih di kotak Product saja
>> pakai makro ndak boleh ya?
>>
>> ~siti
>>
>>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)

3a.: Combine Formulas but Result is Different

Posted by: "Fano The Miner" fano.theminer@gmail.com

Sat Sep 24, 2011 11:42 pm (PDT)

DEAR ALL PAKAR EXCEL Mohon bantuannya.. :)

Saya ingin mendapatkan hasil seperti di kolom RESULT "tanpa"
tergantung pada kolom ARRAY dengan kata lain, saya ingin memperoleh
hasil seperti di kolom RESULT namun formula-nya di gabungkan dengan
formula yang di kolom ARRAY, tapi hasilnya kok BEDA yah?? Apakah cara
saya ada yang keliru? Mohon Bantuannya.. :)

[cid:image001.jpg@01CC7B96.225FB430]

Lebih Jelasnya Terlampir File..

Salam...

Fano.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3b.: Re: Combine Formulas but Result is Different

Posted by: "Kid Mr." mr.nmkid@gmail.com nmkid.family@ymail.com

Sun Sep 25, 2011 4:53 am (PDT)

Dear Fano,

Tampaknya beberapa fungsi memiliki kelakuan yang sedikit berbeda ketika
diletakkan dalam sebuah cell dibanding pada sebuah blok array.
Semoga file terlampir bisa memberi gambaran awal tentang hal ini.

Regards.
Kid.

2011/9/25 Fano The Miner <fano.theminer@gmail.com>

> **
>
>
> DEAR ALL PAKAR EXCEL Mohon bantuannya.. :)
>
> Saya ingin mendapatkan hasil seperti di kolom RESULT "tanpa"
> tergantung pada kolom ARRAY dengan kata lain, saya ingin memperoleh
> hasil seperti di kolom RESULT namun formula-nya di gabungkan dengan
> formula yang di kolom ARRAY, tapi hasilnya kok BEDA yah?? Apakah cara
> saya ada yang keliru? Mohon Bantuannya.. :)
>
> [cid:image001.jpg@01CC7B96.225FB430]
>
> Lebih Jelasnya Terlampir File..
>
> Salam...
>
> Fano.
>
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

Create New Topic | Visit Your Group on the Web

Messages

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

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

EXCEL FEED

Minggu, 25 September 2011

[belajar-excel] Digest Number 1336

Messages In This Digest (4 Messages)

Messages

Invitation to connect on LinkedIn

Posted by: "suryana sakti" sakti_suryana@yahoo.co.id sakti_suryana

Sat Sep 24, 2011 3:31 pm (PDT)

Re: Validation bersyarat validasi sebelumnya

Posted by: "STDEV(i)" setiyowati.devi@gmail.com siti_vi

Sat Sep 24, 2011 8:25 pm (PDT)

Combine Formulas but Result is Different

Posted by: "Fano The Miner" fano.theminer@gmail.com

Sat Sep 24, 2011 11:42 pm (PDT)

Re: Combine Formulas but Result is Different

Posted by: "Kid Mr." mr.nmkid@gmail.com nmkid.family@ymail.com

Sun Sep 25, 2011 4:53 am (PDT)

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me