2 years ago

#3434

test-img

Jivko Ralchev

VBA message box - how to show a data as a simple table

could someone help with that? How I can show desired data instead of ActiveSheet.. range(...) etc. the same data to appears in single msgbox?

 For Each htmlEle In ieObj.document.getElementsByClassName("ecl-table")(0).getElementsByTagName("tr")
    
    With ActiveSheet

    .Range("A" & i).Value = htmlEle.Children(0).textContent

    .Range("B" & i).Value = htmlEle.Children(1).textContent

    .Range("C" & i).Value = htmlEle.Children(2).textContent

     
   End With

It would be better if it appears like a simple table.

excel

vba

msgbox

0 Answers

Your Answer

Accepted video resources