Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to refresh screen VBA in Excel 97 VBA?

Status
Not open for further replies.
Klopper

Klopper

MIS
Dec 7, 2000
84
US
Hi

How does one refresh the screen programmatically in Excel VBA?

TIA
Klopper
 
Sort by date Sort by votes
Refresh what screen? ----------------------------------------
If you are reading this, then you have read too far... :p

lightwarrior@hotmail.com
 
Upvote 0 Downvote
I have an Excel worksheet which is populated and formatted by a VBA procedure. Some of the cells do not show their formatting unless I page down and page up to refresh the screen...
 
Upvote 0 Downvote
Hi Klopper,

Try:

Code: 
   Application.ScreenUpdating = true
[\code]

Nath
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

thanhthanh12
  • Locked
  • Question
Help vba
Replies
3
Views
332
combo
combo
Andrzejek
  • Locked
  • Question
Outlook VBA - Trust access
Replies
3
Views
464
hermanlaksko
hermanlaksko
xwb
  • Locked
  • Helpful tip
Performing VBA operations in other languages
Replies
1
Views
233
strongm
strongm
SLW89
  • Locked
  • Question
VBA newbie needs help
Replies
4
Views
287
Andrzejek
Andrzejek
remeng
  • Locked
  • Question
Run PowerShell Commands from Excel VBA
Replies
14
Views
2K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top