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

Occasional Contributor

Hi,

 

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