Cells(1, 3) = "Last update : " CStr(Now())End Subregards Hugh code before your suggestion it runs OK - but note that I do not need to do this on the other sheets.
Have you tried; Public Sub Send Query() Dim delay As String Dim uname As String Sheets("RETU"). Clear Contents ' code snipped, but essentially Active X call ' inform user of update: Sheets("RETU").
Sound singles chat without registration - Visual basic screenupdating
You must set the Screen Updating property to True when the procedure finishes or when it stops after an error.
You can increase the speed of some procedures by keeping screen updating turned off. Insert Paragraph After End With If x Mod 50 = 0 Then Active Document.
I have a Sub in a module which calls Subs on individual sheets. I have a command button on the first sheet which starts timer/poller code in Module1 which in turn calls the Get Positions() Sub above.
The Sub in the individual sheets needs to clear a range of cells, but I do not wish the focus to change to any of these sheets from the one the user is viewing. The issue I am facing is that Clear Contents requires the range/sheet to be selected, causing focus to be changed. Here are the code snippets: Module Code Sub Get Positions() Application. Is it the fact that the button is on a different sheet? BW Brian, This is working for me given 2 sheets and the following code under a button on sheet 1; Private Sub Command Button1_Click() Sheets(2).
Some of this is covered in Steve Brown's book "Visual Basic Developer's Guide to the Win32 API". The reason that i am doing this: I want to make games that can be played in a corporate environment without being detected. It takes quite some time to get the image onscreen, because it seems to be impossible to copy an array containing the pixel colors into the .
So:- No executables, No registry editing- Only office-extensions (like .xls, etc)- Max filesize 200 KB- All game resources (sounds, maps, etc) should be inside the file or be pre-installed on a corporate machine (such as the sounds from C:\Windows\Media)So far, i've developed some grid-based games (Tetris, Snake and Mines) for Excel. Remarks Turn screen updating off to speed up your macro code.You won't be able to see what the macro is doing, but it will run faster.It certainly would be faster to use a Create Compatible DC function (Lib "gdi32") and do your manipulation there, in memory, and then dump it back to the screen in toto. Gerry Well, I've made some improvement with this combination: Lock Window Update (Find Window("XLMAIN", vb Null String)) Call Send Message(Find Window("XLMAIN", vb Null String), _ WM_SETREDRAW, 0&, By Val 0&) Update Objects Call Send Message(Find Window("XLMAIN", vb Null String), _ WM_SETREDRAW, 1&, By Val 0&) Lock Window Update 0However, as you said, using more than say 40 visible objects at once, really slows the framerate. btw: The Bitmap Viewer as well as the Ascii converter only swallow 24-bit Bitmaps.This is much much faster than drawing directly to the window DC. Using system wide API calls also doesn't pass any beauty contests. More of my own inventions (or better: re-creations) can be found at: More games (but as I recently discovered, other people did the same and better)home.1asphost.com/gijsterbeek/Snake XL.xlshome.1asphost.com/gijsterbeek/Tetris XL.xlshome.1asphost.com/gijsterbeek/Mines Some Bitmap To ASCII converterhome.1asphost.com/gijsterbeek/Ascii Draw And a Bitmap Viewer/Editorhome.1asphost.com/gijsterbeek/Bitmap About this last one i have a question. All, In vba, I can turn off screen redrawing activities by setting screenupdating = false.