Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As 
Boolean)
   Dim Kuning As Range, sheetName As String, Bikini
   Set Kuning = Range(Range("B4"), Range("B4").End(xlDown))
   
   If Target.Cells.Count = 1 Then
      If Len(Target.Value) > 0 Then
         If Not Intersect(Target, Kuning) Is Nothing Then
            sheetName = "(" + CStr(Target(1, 0).Value) + ")"
            If IsSheetFound(sheetName) Then
               Sheets(sheetName).Select
            Else
               MsgBox "Tidak ada sheet benama " & sheetName & " ..tauk ?!", _
               48, "Ellol.. Mang..."
               Bikini = MsgBox("Apakah sheet tersebut mo di Bikini?!" & vbCrLf 
& _
               "Waduh,...... maksud teh di Bikinin?", 36, "Ellol.. Mang...")
               If Bikini = vbYes Then
                  Sheet2.Copy After:=Sheets(Sheets.Count)
                  ActiveSheet.Range("b3") = Target(1, 0).Value
                  ActiveSheet.Name = sheetName
               End If
            End If
         End If
      End If
   End If
   Cancel = True
End Sub

taaa kituuu...

  ----- Original Message ----- 
  From: Khozhot 
  To: belajar-excel 
  Sent: Monday, February 01, 2010 8:21 AM
  Subject: Fwd: Re: [belajar-excel] Other Link


  ---------------------------------------
  mods note
  email ini masuk ke grups di folder spam 
  kenafa ya...
  ----------------------------------------
  Colly......
  Q resend lage dach, ternyata ada reportnya bahwa imel ini gak sampe
  ke millist pada hal dah macuk sent folder.
  Maaf q kurang telik. I made all of you confused about it. I guess.
  Email sebelumnya ada dibawah email ini.
  I am waiting for it, please.
  TQ B4,
  Wassalam.
  ...zhot thea

  ------- Forwarded message -------
  From: Khozhot <[email protected]>
  To: [email protected]
  Cc:
  Subject: Re: [belajar-excel] Other Link
  Date: Sat, 30 Jan 2010 16:23:03 +0700

  Aaa .... sou desu ka !?!
  Hai, watashi wa wakarimasta. Doumo arigato gozaimasu xi...xi...xi.....

  Sebenarnya q pengen buat schedule seperti terlampir.
  Jadi begitu pencarian tidak diketemukan, tidak usah hubungi Team SAR. Yang  
  pasti q tanbahin agar langsung dibuatkan sheet tersebut getoch  
  xi...xi....xi....
  Tapi,...... malah timbul masalah baru nech.

  CELL yang berisi qty jadi ilang gak keliatan karena width nya gak memadai,  
  gimana yach codenya agar bisa autofit ketika langsung di kopi?

  Maaf... jadi ngelunjak nech....... heu...heu....heu....

  Wassalam.
  ...zhot thea

Kirim email ke