vba - Too many shapes slow down the code

[Tornado1981]

Hi,
I have a sheet with about 600 shapes.
One of them (just one) is assigned to a macro that opens a simple userform.
When i click on it, it takes too much time to open the userform.
When I delete all other shapes, it opens faster.
I would really appreciate your help to solve this problem.
Thank you in advance.

 

[NoSparks]

Care to let us see the assigned macro that opens the simple user form ?

 

[My Aswer Is This]

What are these 600 shapes used for?
I surely hope you do not have 600 shapes with each one assigned to a different script.
There are a lot better ways to do things.

And any time you have a question about a script it's always best to show us the script.

Maybe your Userform initialize script has a lot in it. Show us that script also.

 

[Tornado1981]

None of the shapes are assigned to a script .. They are just shapes
Only one is assigned to a macro that opens a userform

Public Sub OpenAboutWindow()
    IAbout.Show False
End Sub

 

[My Aswer Is This]

A lot of UserForms have a Initialize code which runs when the UserForm Opens.

It looks something like this:

Private Sub UserForm_Initialize()
ListBox1.List = Range("A1:A20").Value
End Sub

Do you have one?
If so show us this code.

 

[Tornado1981]

No I have no codes in the userform initialize or activate events.

 

[My Aswer Is This]

I'm sorry I have no answer for you. Not sure why 600 shapes would cause your UserForm to load slowly.
Do any of your other Vba scripts run slowly?
I would imagine having this many shapes could cause things to run slowly. Depending on what type shapes and how large they are. And then what does open slowly mean. 1.0 milliseconds or 3 seconds. And how many controls on the UserForm etc. etc.

Try:
IAbout.Show Modeless

 

[L. Howard]

Although this applies to Excel 2007, other discussions mention that numerous shapes (and their formatting) can slow performance quite a bit.

I did not see any sure fire methods suggested to solve the problem.

Howard


[h=3]Shapes and slow VBA code in Excel 2007 - Ron de Bruin[/h]