https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/2607.aspxTue, 20 Jun 2006 14:41:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:2607dlgross0https://www.infopathdev.com:443/forums/thread/2607.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=2607The range property needs to be assigned to an Object (e.g. the worksheet needs to be defined)https://www.infopathdev.com:443/forums/thread/1366.aspxMon, 19 Jun 2006 11:58:02 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:1366G105ALY0https://www.infopathdev.com:443/forums/thread/1366.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=1366Hi guys,<br /><br />I am using VBA in Excel with imported data, can anyone tell me why this code won't work:<br /><br />Sub Test()<br />Dim mycomment As String<br />mycomment = Range("a1")<br />Range("a1").Comment.Text.mycomment<br />End Sub<br /><br />I want it to show the contents of a cell in a comments box. Any help would be most appreciated?