Results 1 to 13 of 13

Thread: Excel 97 Screen Refresh (Resolved)

Threaded View

  1. Apr 3rd, 2004, 01:55 PM #1
    TheFIDDLER
    TheFIDDLER is offline

    Thread Starter
    Lively Member TheFIDDLER's Avatar
    Join Date
    May 2002
    Location
    here and there and far away
    Posts
    126

    Excel 97 Screen Refresh (Resolved)

    Anyone have a bit of code that I can use to force a screen refresh using VBA in Excel 97.

    I know of the ScreenUpdating = true property, but I think I am looking more for a ScreenUpating = NOW property.

    I ran accross a reference to a ScreenRefresh method in "Excel 2002 VBA" by Wrox Prex, but they just hint at it and never give an example or actual setup for it. I can't find it in the application model for 2002 or 97.

    ScreenUpdating works to show commands as they happen. I want to refresh the screen -after- all the fun stuff has happened. Kind of like sending a wakeup call to the system to show the current status at that point in time.
    Last edited by TheFIDDLER; May 14th, 2004 at 09:09 PM.
    -----
    #VBA, VB 6 Professional Edition, Office XP Developper. Excel 97, Excel 2000, Excel XP

    I miss my VIC 20.
    Never should have upgraded to my commodore 64. ...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width