Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code hangs up on standard formatting
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code into MS Object Sheet Hangs up | Excel Programming | |||
Code hangs second time around | Excel Programming | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) | |||
.NET code hangs setting up a chart | Excel Programming | |||
Code hangs Excel ... Why? ... and how can i debug?? | Excel Programming |