Automation error when calling UserForm

[Guinaba]

Hey guys,

Any suggestion how to avoid this error? That is happening when I am calling a userform to show charts placed in another worksheet, but I am getting the same error even when placing the button in the same sheet as the charts.

Sub LoadChartsForm()

    ChartsForm.Show

End Sub

 

[davesexcel]

Usually when the "Userform.show" errors, there is a problem in the useform initialize code

 

[Guinaba]

Usually when the "Userform.show" errors, there is a problem in the useform initialize code

@davesexcel did you mean the ChartsForm.Show? I don’t see any issues in the code

 

[Guinaba]

@davesexcel excel

'This loop helps to avoid the memory issue when opening the userform having the charts.
Do While Not Application.Ready
DoEvents
Loop