problem in formatting comment

[karthikeyan]

dear friend,

i am adding comment in my "G4" row using VBA code.becos i am reading from xml.so this is dynamic population.my comment should be like this:

i have 1000 datas. so

karhtik mano padhu mini
mani bani sara msla
daya dei gen millu


like this i need to show in comment.so please how to d olike this please show some sample code for this

[Siddharth Rout]

dear friend,

i am adding comment in my "G4" row using VBA code.becos i am reading from xml.so this is dynamic population.my comment should be like this:

i have 1000 datas. so

karhtik mano padhu mini
mani bani sara msla
daya dei gen millu


like this i need to show in comment.so please how to d olike this please show some sample code for this

I am sorry, I didn't understand. Two questions...

1) How do you decide what goes in the comment for the 1000 piece of data? or
2) Do want the above text to go as comment in all that 1000 piece of data?

[karthikeyan]

please do any one reply me please

[Siddharth Rout]

please do any one reply me please

[Hack]

please do any one reply me please

koolsid did reply, and asked two questions.

What are the answers to those questions?

[karthikeyan]

dear friends,

i am reading those 1000 values from xml and i have to addcomment in "G4" range and i have to populate those 1000 value in comment as like follows
ex:

karhtik mano padhu mini
mani bani sara msla
daya dei gen millu


there every names are in my xml. i can able to loop through my xml values. but i would like to add comment and pass the reading values in comment like the above example.i think now it is clear.please help me to solve this pl.......

[westconn1]

range("g4").AddComment "this is" & vbnewline & "a test" & vbnewline & "to see" & vbnewline & "if it works?"

[karthikeyan]

hi, iam looping through the xml to add comment text as follows:

Dim articleDoc As New DOMDocument
  Dim NodeList As IXMLDOMNodeList
  Dim sectionNode As IXMLDOMNode
  Dim rng As String
  Dim index As Integer
  Dim comment As comment
  Dim strcomment As String
  
   
    Dim lngIndex As Long
     Dim lngChild As Long
    articleDoc.async = False
    articleDoc.validateOnParse = False
    articleDoc.preserveWhiteSpace = False
    articleDoc.Load strFileName
       Set OrgComment = Range("G4").Addcomment("Names")  
          
    Set NodeList = articleDoc.selectNodes("//Name")
    
    For Each sectionNode In NodeList
     
     'add  values in comment
    Next

so i have to add reading values from xml in comment inside the loop. i do have 1000 names in my xml.so in comment 4 names per line with some space.so show me some sample code how to do this please help me to write code inside the loop