Coba pake script ini, copas di module, tapi untuk A6 saya belum paham maksudnya
data dimensi.
Sub Buat_Comment()
With Range("A2")
.ClearComments
.AddComment
.Comment.Visible = False
.Comment.Text Text:="user:" & Chr(10) & "Selamat Datang"
End With
With Range("A4")
.ClearComments
.AddComment
.Comment.Visible = True
.Comment.Text Text:="user:" & Chr(10) & Range("D10").Value
End With
End Sub
From: [email protected] [mailto:[email protected]]
Sent: Thursday, September 18, 2014 7:12 AM
To: [email protected]
Subject: [belajar-excel] bagaimana perintah untuk comement.
Mohon bantuannya.
Mau bikin
comment di a2 --- > "Selamat datang"
comment di a4 --- > mengambil data dari cells( 4,10)
comment di a6 --- > mengambil data dari ket1 ----> data dimensi
dalam Macro
Salam
Lukman
