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,
- When cell value changes show pop up message, image or splash screen
- then refresh query
- 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
