2 years ago
#3434
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