Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 21st 07, 01:14 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 40
Default VB Crash - Little Bit Of Fun

Hello

I've been messing around with VB and managed to write a code which crashes
my pc, any reason why ???

I have a dual core 2.5 ghz, vista and excel 2007. Screen went white and
froze for 10-15 seconds.

Maybe someone else could try and see if it happens to them? Surely I didnt
overload or confuse Excel with this;

For s = 0 To 65535 Step 5

Cells(4, 4).Interior.Pattern = xlSolid
Cells(4, 4).Interior.Color = s

Next s

Thanks

  #2   Report Post  
Old May 21st 07, 01:29 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 9,101
Default VB Crash - Little Bit Of Fun

Another office 2007 problem. works fine with 2003.

"RajenRajput1" wrote:

Hello

I've been messing around with VB and managed to write a code which crashes
my pc, any reason why ???

I have a dual core 2.5 ghz, vista and excel 2007. Screen went white and
froze for 10-15 seconds.

Maybe someone else could try and see if it happens to them? Surely I didnt
overload or confuse Excel with this;

For s = 0 To 65535 Step 5

Cells(4, 4).Interior.Pattern = xlSolid
Cells(4, 4).Interior.Color = s

Next s

Thanks

  #3   Report Post  
Old May 21st 07, 01:51 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 340
Default VB Crash - Little Bit Of Fun

Works fine if you put

Application.Screenupdating = false

before your For. Sounds like you are over loading Excel's ability to update
the screen as your code requires it to refresh the screen over 13,000
times.....

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"RajenRajput1" wrote in message
...
Hello

I've been messing around with VB and managed to write a code which crashes
my pc, any reason why ???

I have a dual core 2.5 ghz, vista and excel 2007. Screen went white and
froze for 10-15 seconds.

Maybe someone else could try and see if it happens to them? Surely I
didnt
overload or confuse Excel with this;

For s = 0 To 65535 Step 5

Cells(4, 4).Interior.Pattern = xlSolid
Cells(4, 4).Interior.Color = s

Next s

Thanks



  #4   Report Post  
Old May 21st 07, 01:54 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 40
Default VB Crash - Little Bit Of Fun

Looks like we've gone 4 years back, not 4 years forward



"Joel" wrote:

Another office 2007 problem. works fine with 2003.

"RajenRajput1" wrote:

Hello

I've been messing around with VB and managed to write a code which crashes
my pc, any reason why ???

I have a dual core 2.5 ghz, vista and excel 2007. Screen went white and
froze for 10-15 seconds.

Maybe someone else could try and see if it happens to them? Surely I didnt
overload or confuse Excel with this;

For s = 0 To 65535 Step 5

Cells(4, 4).Interior.Pattern = xlSolid
Cells(4, 4).Interior.Color = s

Next s

Thanks

  #5   Report Post  
Old May 21st 07, 02:35 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 40
Default VB Crash - Little Bit Of Fun

Its a shame that your line of code doesn't allow the colors to change on the
screen

But its good to know that code


I placed another for loop inside the original, just a dummy to slow it down,
and it worked, but obviously not very efficient



"Bob Flanagan" wrote:

Works fine if you put

Application.Screenupdating = false

before your For. Sounds like you are over loading Excel's ability to update
the screen as your code requires it to refresh the screen over 13,000
times.....

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"RajenRajput1" wrote in message
...
Hello

I've been messing around with VB and managed to write a code which crashes
my pc, any reason why ???

I have a dual core 2.5 ghz, vista and excel 2007. Screen went white and
froze for 10-15 seconds.

Maybe someone else could try and see if it happens to them? Surely I
didnt
overload or confuse Excel with this;

For s = 0 To 65535 Step 5

Cells(4, 4).Interior.Pattern = xlSolid
Cells(4, 4).Interior.Color = s

Next s

Thanks






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Crash on mouse click SpartyTower Excel Discussion (Misc queries) 0 November 8th 06 04:31 PM
Filtering crash cj21 Excel Discussion (Misc queries) 0 December 14th 05 04:03 PM
Excel Crash - Help! Delbert Excel Discussion (Misc queries) 13 December 13th 05 11:02 PM
Excel 2003 Crash Delbert Excel Discussion (Misc queries) 0 December 12th 05 09:21 PM
Crash martin Excel Discussion (Misc queries) 2 July 13th 05 09:36 PM


All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017