Excel: Get cell comments

Categories: Development Notes; Tagged with: Excel; @ August 23rd, 2012 19:05

1. Alt + F11, in the opening window, click: Insert>Module, paste the folling code:

Function getComment(incell) As String
On Error Resume Next
getComment = incell.Comment.Text
End Function


2. Alt + Q to quit the window

3. use the funciton in cell, like:
=getComment(A1) , will fill the cell with A1’s comments

 

The difference between DELETE and TRUNCATE <-> SSMS(SQL Server Management Studio) can not edit SQL Agent Job steps

---

ActionScript Adobe AIR ANT Apache ApacheFlex Apache Flex Better Developer BlazeDS Cloud Computing CMD DataGrid DataGridColumn DB2 Derby DTSX Eclipse ETL Event Excel Flash Builder Flex Google Java JDBC JDK JIRA Life@SG|新加坡 Linux MySQL Oracle PHP Python RegEx Servlet SQL SQL Server SSIS SVN T-SQL Tools Tree Ugly WordPress XML dev-notes side-projects