Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Thread Tools Search this Thread Display Modes
Old Apr 14, 2008, 11:42 PM   #1
macrumors newbie
Join Date: Apr 2008
cells don't update on Mac Excel 2004 when using VBA


I'm sure someone must have noticed this before but so far I haven't been able to find a solution searching the web (if there is one). I've written a a simulation in VBA and it works on the PC ok. The simulation updates cells on a worksheet as it runs to show how the simulation is proceeding, but NOT on a Mac(Leopard 10.5.1.) with Excel 2004.

A simple subroutine demonstrates what I mean

Sub Test()
Dim i As Integer

For i=1 to 1000
Range("A").value = i
Next i

End sub

On Excel on the PC you see the cell A increasing to 1000 (very fast) as you run the macro, but on the Mac it only seems to update the cell after the macro finishes. This you see the cell go from blank to 1000 (after several seconds!). This really makes the user interface pretty hopeless in my simulation.

I'd be grateful for any help on this

dawitika is offline   0 Reply With Quote

MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
thread Thread Starter Forum Replies Last Post
iMessage on Mac -BigMac- Mac OS X 10.7 Lion 50 Feb 19, 2012 10:01 PM
When will the next Mac Pro be announced jtmacb Mac Pro 55 Feb 24, 2011 05:23 AM
Cells on Mac Excel 2004 don't update dawitika Mac Applications and Mac App Store 0 Apr 14, 2008 12:47 AM
I don't want my Mac to sleep when on power! dmurray14 OS X 4 Jun 26, 2006 06:25 PM
Mac Office 2004........WHEN ? patriotn11 Mac Applications and Mac App Store 10 May 7, 2004 06:02 PM

All times are GMT -5. The time now is 11:01 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013,, LLC