Refreshing

SQUIDD

Well-known Member
Joined
Jan 2, 2009
Messages
2,107
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Hello

I have a macro that cycles a whole load of pages and imports data.Is there a way i can have it show just 1 page while it is doing its thing.The page showing will have data on it that changes so i would want it to show the updated data.

This may be a simple way for me to have a progress moniter.
Any advice.

Dave
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
This:

Application.ScreenUpdating = False

will suppress screen refreshes. You can set it to True when you want, but if you have activated another sheet, that's the one that will appear on the screen.
 
Upvote 0
thankyou for your help.

I was hoping that 1 page would be able to stay on display refreshing.
Never mind.

Dave
 
Upvote 0
If you avoid activating the other sheets the initial sheet will always be displayed. It's rarely necessary to activate/select objects in VBA in order to work with them.
 
Upvote 0
Hi andrew

Thanks for your help, so you are saying if i stop screen updating and start the macro running from that page that screen will always display and when data changes on that sheet it will also change.

I will give it a go.

Dave
 
Upvote 0
You can also read and write information from and to other sheets without actually selecting or activating them, most of the time (with most types of data manipulation). Just avoid doing things like

Sheets("Sheet2").Select or .Activate, and don't rely on things like Selection.Copy - just tell Excel which areas to copy or paste or manipulate without actually selecting them.
 
Upvote 0
Thankyou for your help.
I have made something that works well.
I have to make screenupdating true just for 1 bit then make it false again.
works excellent.

Dave
 
Upvote 0

Forum statistics

Threads
1,216,373
Messages
6,130,226
Members
449,567
Latest member
ashsweety

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top