Is this a bug ?

[Jaafar Tribak]

Hi all and happy new year.

I have a userform with a single multipage control on it.

In the form activate event, I add a new tab to the multipage as follows :

Private Sub UserForm_Activate()
Me.MultiPage1.Pages.Add
Me.MultiPage1.Pages(Me.MultiPage1.Pages.Count - 1).Name = "testpage"
Me.MultiPage1.Pages(Me.MultiPage1.Pages.Count - 1).Caption = "testpage"
End Sub

So far, everything works fine and the new tab is added as expected.

Now, here is the problem:

If I have a seperate Frame control or a seperate MultiPage anywhere on the form and I run the above code, the entire excel application crashes and closes !!

I have no other code behind the userform. In fact, I have tested this in a blank fresh workbook\Form and still crashes excel !

I have no idea why having a frame or a another mulipage on the form will cause the above code to crash the entire application.

Does this happen to you guys ? Is this a known bug ?

I am using excel 2016 x64bit .

Thanks.

 

[RoryA]

I get an automation error (the object invoked has disconnected from its client) but Excel doesn't actually crash unless I try and step through the code. (Excel 2016 32bit)

 

[Fluff]

I get the automation error & then excel crashes, using 365 32bit

 

[ISY]

Hi

Using Excel 365 64bit channel beta, no crash!

 

[Jaafar Tribak]

Thank you guys for testing and confirming the issue.

I don't even get an error - just straight freezing of excel and then closing.