Splash Screen or Message Pop up or Image display while query is being refreshed

Copper Contributor



I do not know how to create VBA codes for macros in excel and was wondering if someone could help me. I was able to find a code on the internet that will help to refresh one specific query in my excel file which is triggered by a change in a cell value.


At times the background refresh process takes time. So from a user interaction perspective I was wondering if there is a way to put up a splash screen, pop up or image while the refresh process is going on, is this possible?


I was thinking if there was a code that could action the tasks in the following steps,

  1. When cell value changes show pop up message, image or splash screen
  2. then refresh query
  3. then hide/remove pop up message, image or splash screen


Here is the code that currently have to start the refresh query when a cell value changes in the sheet.




Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = Range("C2").Address Then

    ActiveWorkbook.Connections("Query - Onshore_list").Refresh
End If
End Sub



Thank you


0 Replies