PC Review


Reply
Thread Tools Rate Thread

code hangs up on standard formatting

 
 
c1802362
Guest
Posts: n/a
 
      13th Dec 2008
I have a app that runs a userform. The first time through, the
application takes about 15 seconds to execute. Any subsequent run of
the userform is instantaneous.

I traced the delay to the following code snippet. The code creates a
balloon (circle shape), inserts a number (numbers run from 1-99) from
the spreadsheet into the circle, formats it, then places it in a
specified X-Y position on another sheet. The offending code appears to
be:

With Selection.Characters(Start:=1, Length:=2).Font
.Name = "Arial"
.Size = 9
.FontStyle = "Bold"
.ColorIndex = 2
End With

Any suggestions why?

Art
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Visual Studio 2005 Standard Hangs with 50% CPU time. Edwin Smith Microsoft C# .NET 3 27th Feb 2007 08:30 PM
copying vba code to a standard code module =?Utf-8?B?MXZhZ3Jvd3I=?= Microsoft Excel Misc 2 23rd Nov 2005 04:00 PM
This code hangs on connect() if connect hangs. how to make this so that if connect hangs i time out after 10 seconds. perhaps there is someway to do this with ioctlsocket and select? can anyone show how to do this? Daniel Microsoft Windows 2000 Networking 0 15th Feb 2005 01:37 AM
VB. NET 2003 Standard hangs opening Windows forms Nick Rogers Microsoft Dot NET 0 30th Apr 2004 11:17 PM
Currency and Standard formatting Mercer Microsoft Access Reports 1 6th Apr 2004 04:43 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:03 PM.