I have a command button that I want to click on and it would refresh the cell that is imported with web data but I dont know the codes for this in VBA
is this possible? anyone knows?
I have a command button that I want to click on and it would refresh the cell that is imported with web data but I dont know the codes for this in VBA
is this possible? anyone knows?
How did you get the external data in the first place?
If you used a web query, that makes it simple.
Example of refreshing a web query:
![]()
Sub refreshWebQuery() Dim qt As QueryTable Dim ws As Worksheet Set ws = Sheet2 Set qt = ws.QueryTables(1) qt.Refresh End Sub
thank you. again![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks